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 |
|
sanjay5219
Posting Yak Master
240 Posts |
 Posted - 2012-05-04 : 08:00:30
|
| Hi All,Can i restore SQL 2005 Backup(.bak) in Sql 2000Please suggest |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2012-05-04 : 09:36:33
|
| No it is not possibleMadhivananFailing to plan is Planning to fail |
 |
|
|
sanjay5219
Posting Yak Master
240 Posts |
Posted - 2012-05-04 : 12:44:04
|
| Do we have any solution because i have come in one scenario where i have to do thisplease suggest |
|
|
|
sanjay5219
Posting Yak Master
240 Posts |
Posted - 2012-05-04 : 12:44:47
|
| Can i use ldf and mdf file of sql 2005 in sql2000 |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-05-04 : 12:53:59
|
| No. You'll have to export the data from 2005 to 2000 using SSIS or similar ETL software. Or export to text files using bcp and then import into SQL Server 2000. |
|
|
|
sanjay5219
Posting Yak Master
240 Posts |
Posted - 2012-05-04 : 13:14:18
|
| Another silly thoughtCan i install SQL Server 2000 on Windows Server 2008 64 Bit with SQL 2005 so that i can do import and exportPlease suggest |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-05-04 : 13:20:11
|
| I'm not sure if SQL Server 2000 is supported on Windows Server 2008 64 bit. And even if it was, why do you need to install SQL 2000 if you already have the database in SQL 2005? |
|
|
|
|
|
|
Sql Backup