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 |
|
TonyTheDBA
Posting Yak Master
121 Posts |
 Posted - 2007-01-23 : 08:40:44
|
| I have been sent a backup file from a supplier that I have been trying to restore. I have succesfully installed it on my SQL2K5 instance, however, we need to put it on our SQL Server in our DMZ . . . Which is running SQL2K . . . Supplier was informed of this and says that you can restore to a SQL2K DB as long as you use SQL Management Studio . . . Tried that and got an error message Saying That Restore Headeronly is terminating - Too many backup devices specified. . . only 64 are allowed. . . .Supplier suggests that its a SP4 issue . . . Installed SP4 and tried again . . . Got the Same Error again (SQL Server Error :3205)Am I out of my gourd I am sure that restoring a SQL2K5 Backup to a SQL2K instance is not possible?I should say that I am Running SQLExpress as my 2K5 Instance and MSDE as my 2K instance . . . Before I invest more time on this and trying it on a development server running Standard edition.Thanks All-- RegardsTony The DBA |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-01-23 : 08:56:58
|
you can't restore a ss2k5 db to a ss2k server.Go with the flow & have fun! Else fight the flow  blog thingie: http://weblogs.sqlteam.com/mladenp |
 |
|
|
TonyTheDBA
Posting Yak Master
121 Posts |
Posted - 2007-01-23 : 09:45:30
|
| Excellent, thats exactly what I wanted to Know-- RegardsTony The DBA |
|
|
|
TonyTheDBA
Posting Yak Master
121 Posts |
Posted - 2007-01-23 : 11:48:25
|
| Suppliers say they can do it on there version :) even sent a full set of instructions on how to do it in SSMS . . . So I sent them the script I use (The GUI is Evil) . . . Oh and I also sent them the output from the script and the screenshot of the GUI error message. They returned the MDF files they get when they restored the backup . . . I Tried to attach them . . . No Go SQL 2K5 . . . Rhetorical Question "Why are all suppliers muppets?" . . . Which leads on to another "Why is it all MY suppliers are muppets?" :)Went back to my original idea. Script out the Dtabases in SQL2K5, Run the script in QA in SQL2K, Create a SSIS script to populate the tables . . . Sorted-- RegardsTony The DBA |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-01-23 : 11:52:03
|
yes SSIS does work  Go with the flow & have fun! Else fight the flow blog thingie: http://weblogs.sqlteam.com/mladenp |
|
|
|
|
|
|
Restoring SQL2K% to SQL 2K - Possible?