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.
| Author |
Topic |
|
denise
Starting Member
14 Posts |
 Posted - 2006-03-20 : 16:02:53
|
| Can I use a full database backup file of a mssql7 user database to restore on an already installed msssql2000 system? Is it a simple as just putting a copy of the backup file onto the other server and restoring? Would we need to stop/start the server after the restore?Thanks very much for all help. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-03-20 : 16:34:03
|
| Yes it is as simple as that. It will upgrade the database to SQL Server 2000 during the restore, however the compatibility level will be 70. So if you want to use 2000 features, then you must change the compability level to 80. No you won't need to stop/start the services or the server after the restore.Tara Kizeraka tduggan |
 |
|
|
denise
Starting Member
14 Posts |
Posted - 2006-03-20 : 17:21:44
|
| Thanks, I will be doing the restore sometime this week. |
|
|
|
|
|
|
restore mssql7 user database on a mssql2000 instal