November 12, 2004 at 2:37 pm
I am trying to move an entire SQL Server 2000 database to a brand new server. I created the new database in SS2000, then ran DTS and got all the data; however, I'm missing everything else... sp's, jobs,..., etc. In newbie terms, how do I get everything else transferred to the new server?
I tried creating a backup of the old db on the old server, but I'm not able to see it when I try to restore it to the new db on the new server. There has got to be an easy way to do this, right?
Thanks,
Al
November 13, 2004 at 1:13 pm
http://support.microsoft.com/default.aspx?scid=kb;EN-US;314546
http://support.microsoft.com/default.aspx?scid=kb;EN-US;240867
http://support.microsoft.com/default.aspx?scid=kb;EN-US;240872
http://support.microsoft.com/default.aspx?scid=kb;EN-US;221465
HTH
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy