Wednesday, March 7, 2012

Backup and restore question plz help!

If i have old full database back up of master and msdn and every other database that i had on a old sql server 2000 enterprise. can i use the back up file to recreate the same eviroment on a new installed fresh sql server 2000 enterprise boxYes you can restore to the original state.|||The instance must have the same Service-packs already applied however. For example, If the backups are from SQL with service pack 3. Master won't restore on an SQL without this service pack.

No comments:

Post a Comment