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 |
rammohan
Posting Yak Master
212 Posts |
Posted - 2007-01-12 : 00:15:57
|
hi, at first i had used sqlserver2005 and i created datbase named vb.mdb. at he time time of formatting the system i had taken the back up,it has turned into vb.bak file. now later on i installed sqlserver2000 in my system, now i need to restore this databse into this sqlserver2000. my sqlserver2000 is nativeclient, i have server in my oofice and sqlserver2000 is there in that system, so we r connecting to that. can u tell me the procedure to restore my database. |
|
Kristen
Test
22859 Posts |
Posted - 2007-01-12 : 01:05:58
|
You can not restore a Backup made with SQL2005 in SQL2000.You will have to create a script from the SQL2005 database, use that to create a database in SQL2000 (having removed any SQL2005-specific features that you may have used), and then transfer the data - e.g. using DTS (you will have to resolve any databases not supported under SQL200, if you have used any)Kristen |
|
|
MohammedU
Posting Yak Master
145 Posts |
Posted - 2007-01-13 : 02:27:10
|
Backup restore is one way highway... if you want to go back you have to take a side roads like BCP/DTS:)MohammedU |
|
|
|
|
|