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 |
|
X002548
Not Just a Number
15586 Posts |
 Posted - 2004-05-03 : 13:35:54
|
OK...it's been a while since I restored 7.0But don't I need the mdf and ldf equivilantThey're giving me this 12 gb *.bak file to restoreI got some time because I told them I need to know the collation...But aren't 7.0 and 2k Restores the same?Thanks Tara....just a case of brain-freeze...Brett8-) |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-03 : 13:45:04
|
| They have the same basic syntax. You can restore a 7.0 database onto a SQL Server 2000 server. When you do the restore, it'll have the database compatibility mode set to 70 though. If you want it to be 2000, change it to 80.What do you mean by MDF and LDF equivalent? The .BAK file is enough to do the RESTORE.Tara |
 |
|
|
|
|
|
SQL Server 7.0 *.BAK