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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Database Restore (Problem)

Author  Topic 

Keshaba
Yak Posting Veteran

52 Posts

Posted - 2007-11-27 : 02:16:57
Hi I Want to restore Sql server 2005 express edition built-in Database in Sql sever 2000.I had kept the backup of sql server 2005 express edition built in database in a pen drive.And I am doing the restore directly from the pen drive in Sql server 2000.Here I m getting the following Error message when I perform the Restore operation (IN sql server 2000):..................
Too many Backup devices specified for Backup or restore,only 64 are allowed .Restore Database is terminated abnormally.Please Help..

There is no problem in Backup and restore operation in my sql server 2000 I Can do restore and backup successfully from the same version.


Keshab

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-11-27 : 02:25:00
No you can't.
Go to Top of Page

Keshaba
Yak Posting Veteran

52 Posts

Posted - 2007-11-27 : 02:50:58
May I know why i Can't ...Can u let me know..

Keshab
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-11-27 : 03:02:01
Try
http://www.codeproject.com/cs/database/MovingSQLServer2005to2000.asp

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

Keshaba
Yak Posting Veteran

52 Posts

Posted - 2007-11-27 : 03:20:37
Okie Thanks For Your Reply...........

Keshab
Go to Top of Page
   

- Advertisement -