January 20, 2006 at 8:01 am
I have two servers running SQL Server 2000 and usually just backup the production server and restore it to a test server that will eventually be our primary server once we get the kinks out of the application running on it.
Is there an easier way to do this? Is replication an option or is there some kind of DTS package I might run? The restore procedure seems to fail if you don't hold your hand just right in front of the screen (exaggerating mode off now). Plus, when I did a restore the last time, the logical filenames changed on me (is that actually a problem, by the way?).
Any help is greatly appreciated, because I'm using the Best Practices Analyzer to make some changes in the new system, such as putting the transaction log on the C:\ drive and the data files on the D:\ drive, and I don't want to undo what I have done just to get some fresh data on the test system.
January 20, 2006 at 8:20 am
Backup restore is the lowest impact option. Detach works as well.
don't mess with DTS, replication,etc.
Be sure you move logins and I'd include msdb in the backup/restore process. search sp_help_revlogin for login movement help.
January 23, 2006 at 7:02 am
I can't find anything on sp_help_revlogin. I searched BOL and microsoft.com and can't find anything on it.
January 23, 2006 at 8:23 am
This should help...
http://support.microsoft.com/default.aspx?kbid=246133#XSLTH3137121122120121120120
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply