November 17, 2004 at 1:32 pm
Here's a question that may not be trivial but is good to know. How do
you move an actual server? I know how to move databases, but then
you dont get Stored procedures, Views, DTS packages, etc, (anything else I'm missing there?)
Whats a good way to move an entire server?
November 18, 2004 at 5:20 am
You're missing the fact, that when you move a db that db includes all of its objects. That is procedures, views, UDFs...
Here are some useful informations
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;274188
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
November 18, 2004 at 9:39 am
So, you want to move a SQL Server instance from one server to another?
We've settled on using scripts to detach and attach databases, create backup devices, create logins, create jobs, save DTS packages to files and backup databases. Frank is right when he says that moving a database moves all it's objects.
The important thing is to plan carefully and test your scripts before trying it for real.
Greg
Greg
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply