duplicate SQL 2K - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

duplicate SQL 2K

Author

Topic

ksung
Starting Member

1 Post

Posted - 2003-03-19 : 07:54:05

My Master Server is running Windows 2K Server (SP3) and SQL 2K Server (SP3). I tried to duplicate a server for testing. Here is what I did,
- Installed exact Windows 2K + SQL 2K on backup server
- Stop SQL Servers on Master and Backup servers
- transfer all the data and log files from Master server to overwrite those on backup server
- start both SQL servers

After that, Enterprise Manager can control SQL 2K on backup server. The same web application can access SQL 2K on backup server without any error.

My question:
Is any potential issue for what I did to duplicate the SQL Server?

Thanks for help.

KSung

JohnDeere
Posting Yak Master

191 Posts

Posted - 2003-03-19 : 09:21:04

I think that should work fine. I have used that technique to duplicate servers for testing myself.

Lance Harra

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources