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 |
|
michaelxvo
Starting Member
47 Posts |
 Posted - 2006-01-26 : 14:53:01
|
| Hi.I am still in training to be database administrator. My office is running MS SQL server 7.0. Everyday, A schedule is set to automatically backup a user database to a network drive (for example \\dc2\data\backup.bak). I recently installed MSSQL Server 2000 120 days evaluation on a computer dc3. I use dc3 SQL Server Enterprise Manager to restore the backup file (\\dc2\data\backup.bak) to a drive on dc3. My question is: IS THIS NEW DATABASE OPERATIONAL? because the backup file was backuped by MS SQL server 7.0. and restored by MS SQL Server 2000.Thank you |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-01-26 : 15:01:05
|
| Yes, you can restore SQL 7 backup files into SQL 2000 (ut not SQL 6.5 and earlier)Kristen |
 |
|
|
michaelxvo
Starting Member
47 Posts |
Posted - 2006-01-26 : 15:21:51
|
| One more question regarding backup and restore database with different version of MS SQL Server.How about if I use SQL Server 2005 to restore a backup file made by MS SQL Server 7.0. The restored database will be restored to MS SQL Server 2005 system. Will the new database operational?Thank you |
|
|
|
kfarlee
Microsoft SQL Server Product Team
9 Posts |
Posted - 2006-01-26 : 16:28:27
|
| Yes.You can restore a backup taken with SQL 7.0 on a SQL 2005 instance. The database will be automatically upgraded to SQL 2005 format.Kevin FarleeSQL Server Engine PM |
|
|
|
michaelxvo
Starting Member
47 Posts |
Posted - 2006-01-26 : 16:47:02
|
| Thank you very much. This concern is with me as I am considering upgrading MS SQL server 7.0 to MS SQL Server 2005 |
|
|
|
|
|
|
Can I restore backup from mssql 7 to mssql 2000