Monday, March 12, 2012

Optimal restore of database

How can I restore Database_1 on MSSQL2K server with minimal effect on working users of Database_2 ?
When I use EM (restore with create), users are getting "General network error" for 5 minutes.Hopefully you're not pulling the backup from across the network. Remember that, restoring does take some taxing on the server resources. However, this should not drop your users.

Take a look at perfmon/netmon to see what's going on.

No comments:

Post a Comment