Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Restore all databases

Status
Not open for further replies.
NoWittyName

NoWittyName

Technical User
Dec 28, 2001
82
GB
I need to reinstall Windows 2000 onto the SQL server. I have been looking into a number of options and would like to find the quickest. I have found that if I format the C:\ drive and install Windows, then SQL server + SP to old level. stop the service and just copy all the old SQL database files including the master,msdb&model back into the SQL data directory, and start SQL server it works. without having to do backup/restore commands.

Is there a reason why I should not be doing this?

Many thanks in advance
 
Status
Not open for further replies.

Similar threads

JoPaBC
  • Locked
  • Question
Schedule and automate backups of SQL Express databases in SQL Server Express 1
Replies
5
Views
458
JoPaBC
JoPaBC
intel233
  • Locked
  • Question
Backup/Restore DB from SQL issues
Replies
2
Views
154
intel233
intel233
lavadan
  • Locked
  • Question
current max value of all int columns
Replies
1
Views
134
fredericofonseca
fredericofonseca
dd2maker
  • Locked
  • Question
SQL server 2008 R2 backup restore issue
Replies
2
Views
124
dd2maker
dd2maker
stanlyn
  • Locked
  • Question
Lockdown all databases except one
Replies
1
Views
112
niall5098
niall5098

Part and Inventory Search

Sponsor

Back
Top