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 |
|
jugnu
Starting Member
1 Post |
 Posted - 2010-08-22 : 15:10:07
|
| HelloI have a database in Sql Server 2008 at home. But i m using Sql Server 2000 in my Office.I need to know is there any way to restore 2008 backup file in 2000?Thanks |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-08-22 : 17:35:22
|
| no, there's not.you can script all the objects and BCP the data out, the bulk insert it in on the 2000 db |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-08-23 : 03:32:46
|
| "and BCP the data out,"Or you can also script the data as INSERT statements - probably not a good choice if there is lots of data, but would be easier for any tables that don't have many data rows. |
|
|
|
|
|
|
Restoring SQL Server 2008 Backup file In SQL 2000