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:
>