Move SQl2000 database to another SQL2000 server

Is there I a KB article on this? I know absolutely nothing about SQL and
could use some help.
Thanks in advance.The database I am wanting to move to a new server is located in
d:\sql\mssql\....
I am wanting to restore it to C:\Program Files\Microsoft SQL
Server\MSSQL\... on a completely different server.
"butter" wrote:
> Is there I a KB article on this? I know absolutely nothing about SQL and
> could use some help.
> Thanks in advance.|||Perhaps this one?
http://www.support.microsoft.com/?id=314546
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"butter" <butter@.discussions.microsoft.com> wrote in message
news:F7C6FF13-9BCF-412F-A7A8-8D6B0B9AF8CA@.microsoft.com...
> The database I am wanting to move to a new server is located in
> d:\sql\mssql\....
> I am wanting to restore it to C:\Program Files\Microsoft SQL
> Server\MSSQL\... on a completely different server.
> "butter" wrote:
>> Is there I a KB article on this? I know absolutely nothing about SQL and
>> could use some help.
>> Thanks in advance.|||Hi,
you will do this in differnet method.
you can take a backup and restore to other server, otherwise you can use DTS
and also you can use attach database by copying the mdf and ldf file to other
server.
hope this will help
Herbert
"butter" wrote:
> The database I am wanting to move to a new server is located in
> d:\sql\mssql\....
> I am wanting to restore it to C:\Program Files\Microsoft SQL
> Server\MSSQL\... on a completely different server.
> "butter" wrote:
> > Is there I a KB article on this? I know absolutely nothing about SQL and
> > could use some help.
> >
> > Thanks in advance.

Move SQl2000 database to another SQL2000 server

Is there I a KB article on this? I know absolutely nothing about SQL and
could use some help.
Thanks in advance.
The database I am wanting to move to a new server is located in
d:\sql\mssql\....
I am wanting to restore it to C:\Program Files\Microsoft SQL
Server\MSSQL\... on a completely different server.
"butter" wrote:

> Is there I a KB article on this? I know absolutely nothing about SQL and
> could use some help.
> Thanks in advance.
|||Perhaps this one?
http://www.support.microsoft.com/?id=314546
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"butter" <butter@.discussions.microsoft.com> wrote in message
news:F7C6FF13-9BCF-412F-A7A8-8D6B0B9AF8CA@.microsoft.com...[vbcol=seagreen]
> The database I am wanting to move to a new server is located in
> d:\sql\mssql\....
> I am wanting to restore it to C:\Program Files\Microsoft SQL
> Server\MSSQL\... on a completely different server.
> "butter" wrote:
|||Hi,
you will do this in differnet method.
you can take a backup and restore to other server, otherwise you can use DTS
and also you can use attach database by copying the mdf and ldf file to other
server.
hope this will help
Herbert
"butter" wrote:
[vbcol=seagreen]
> The database I am wanting to move to a new server is located in
> d:\sql\mssql\....
> I am wanting to restore it to C:\Program Files\Microsoft SQL
> Server\MSSQL\... on a completely different server.
> "butter" wrote:

Move SQl2000 database to another SQL2000 server

Is there I a KB article on this? I know absolutely nothing about SQL and
could use some help.
Thanks in advance.The database I am wanting to move to a new server is located in
d:\sql\mssql\....
I am wanting to restore it to C:\Program Files\Microsoft SQL
Server\MSSQL\... on a completely different server.
"butter" wrote:

> Is there I a KB article on this? I know absolutely nothing about SQL and
> could use some help.
> Thanks in advance.|||Perhaps this one?
http://www.support.microsoft.com/?id=314546
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"butter" <butter@.discussions.microsoft.com> wrote in message
news:F7C6FF13-9BCF-412F-A7A8-8D6B0B9AF8CA@.microsoft.com...[vbcol=seagreen]
> The database I am wanting to move to a new server is located in
> d:\sql\mssql\....
> I am wanting to restore it to C:\Program Files\Microsoft SQL
> Server\MSSQL\... on a completely different server.
> "butter" wrote:
>|||Hi,
you will do this in differnet method.
you can take a backup and restore to other server, otherwise you can use DTS
and also you can use attach database by copying the mdf and ldf file to othe
r
server.
hope this will help
Herbert
"butter" wrote:
[vbcol=seagreen]
> The database I am wanting to move to a new server is located in
> d:\sql\mssql\....
> I am wanting to restore it to C:\Program Files\Microsoft SQL
> Server\MSSQL\... on a completely different server.
> "butter" wrote:
>

Move SQL Database

i am not a sql programmer, but I need to move two "user databases" in a sql
2005 express installation from one drive to another.
This article explains what I need but it says I need to run some commands,
but not where to type the command or run them.
http://support.microsoft.com/kb/224071
Anyway can I just detach, move the data and log file and then reatach it
using the SQL Server Management Studio Express?
ThanksHi
The commands should be run from a SQLCMD prompt at the command line.
If SSMSE is the same as SSMS then you can right click the database node
choose all tasks and then attach from the menus.
John
"frm3389" wrote:
> i am not a sql programmer, but I need to move two "user databases" in a sql
> 2005 express installation from one drive to another.
> This article explains what I need but it says I need to run some commands,
> but not where to type the command or run them.
> http://support.microsoft.com/kb/224071
> Anyway can I just detach, move the data and log file and then reatach it
> using the SQL Server Management Studio Express?
> Thanks|||Absolutely! Go that way if you don't wanna bother yourself with those code
pieces.
Warning:
It those databases are in a production environment, to prevent any data
loss, you may want to change your databases "Restrict Access" property to
SINGLE_USER (from database options) and then do not forget to set it back to
MULTI_USER to avoid any possible chaos :)
--
Ekrem Ã?nsoy
"frm3389" <frm3389@.discussions.microsoft.com> wrote in message
news:14312EB2-50D5-447B-895E-DD861F80AD24@.microsoft.com...
>i am not a sql programmer, but I need to move two "user databases" in a sql
> 2005 express installation from one drive to another.
> This article explains what I need but it says I need to run some commands,
> but not where to type the command or run them.
> http://support.microsoft.com/kb/224071
> Anyway can I just detach, move the data and log file and then reatach it
> using the SQL Server Management Studio Express?
> Thanks|||Thanks for the added advice. That is what I needed.