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.