473,320 Members | 1,872 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

SQL Server 2000 Backup and Restore, Need help!

6
Hi all,

My manager ask me to do backup for 3 database and restore them in a new server.

I did the backup for the 3 database into BAK file. Then in the new server, when I did the restore in SQL Server Enterprise Manager by using their restore function and selecting device(s) for the BAK file, I encounter the different messages such as the following:

1. Microsoft SQL-DMO (ODBC SQLState: 4200) The media family on device 'C:\Backup.BAK' is incorrectly formed. SQL server cannot process this media family. RESTORE DATABASE is terminating abnormally.



Sometimes I got the error message:
'The file on device 'C:\Backup.BAK' is not a valid Microsoft Tape Format backup set. RESTORE DATABASE is terminating abnormally.'


Then I try to do backup for the 3 databases and I uncheck 'Media set name and backup set expiration' under Options for Backup. When I restore them into new server I got the following message:
"Collation ID 49 is invalid. RESTORE DATABASE is terminating abnormally".


I don't understand... I just plainly take the latest BAK file from the server, and I FTP to my own pc to get the BAK files. From my pc I FTP again to the new server to put the copies into the new server directory and I did restore from there. I've read many articles and follow their guides...... But I couldn't get it work...


I really need help for this coz my deadline is tomorrow...... Please help me with this... I don't understand why I cant restore from BAK file... And is it important about media type??? Or anything wrong from my backup? Or restore part??? =(


Thanks!
Smoi
May 8 '07 #1
5 7061
cyberdwarf
218 Expert 100+
When restoring, are you setting restore from device to File? From your post, it sounds like you are trying to restore from a tape device

What versions of SQL Server are you using?

Steve
May 8 '07 #2
smoi
6
When restoring, are you setting restore from device to File? From your post, it sounds like you are trying to restore from a tape device

What versions of SQL Server are you using?

Steve

Hi Steve,

I'm using MS SQL Server 2000, when I backup, I choose to backup in a file as BAK file, not onto the tape. Same like when I do restore, I select From Device and choose the filename.

I think I got some idea about the media set error message... Please correct me if I'm wrong... Does that mean during the time when I do backup, the backup BAK file take note of the harddisk as well??? Since I restore by copying the file into the new server, that may not work... Correct?

Thanks
Smoi
May 9 '07 #3
cyberdwarf
218 Expert 100+
Nope, it doesn't matter where the backup is taken or restored from
May 9 '07 #4
smoi
6
If it doesn't matter where the backup is taken from but now it still doesn't work... I still don't understand what happen???
May 10 '07 #5
smoi
6
If it doesn't matter where the backup is taken from but now it still doesn't work... I still don't understand what happen???

Now I got a new error message saying "Server: Msg 2774, Level 16, State 1, Line 2 Collation ID 49 is not valid."

Can anyone please let me know how to proceed the restoration without having problem for collation ID and media type or media set???
May 10 '07 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Michael Orlando | last post by:
Any help would be greatly appreciated. My problem is that I need to set up a backup SQL Server 2000 machine which can be used in case of a failure to my primary. All databases (30 as of now)...
2
by: Robert Kruk | last post by:
Hello, Recently I've tried to restore backup made on SQL Server 6.5. Unfortunately, the only version of SQL Server I currently possess is SQL Server 2000. I have access only to that backup,...
1
by: dschneiderman | last post by:
Hello All, I am not a SQL Server expert, but I have been put in a pretty precarious situtation and I am close to panicking :( I have need to restore a SQL database from backup (through...
3
by: anguo | last post by:
Hello, I need to set up a development platform at home with a copy of a DB from a SQL server at a friend's company. So far, all my attempts at backup/restore or export/import have failed...
1
by: John Rajendran | last post by:
Hi there, I need to take a backup with the following scanerio in mind: At T1 I take the FULL BACK UP of the database called BACK_1_FULL.BACK in c:\ Then at T2 I would like to take only the...
4
by: Andy J | last post by:
Hi Everyone NEW USER Q. I am trying to restore a database backup image to another machine. Both machines are installed with same DB2 7.2 installation package. Version: 7, Release: 2,...
5
by: HSP | last post by:
hi. i need to restore an old database. The db was backed up using a DLT drive, using 2 volumes. The content for the tapes was copied to file onto Solaris machine using rsh and dd (for backup...
2
by: l0b0 | last post by:
I'm working on a restore procedure for the case where all MDF files are missing, but the LDF files are all intact. A full backup is done every 24 hours, and a log backup is done every 3 hours....
5
by: Seguros Catatumbo | last post by:
Hi, i am using sql server 2000, and i make daily backups. I want to restore my backup to a test msde database i have. I don't know how i did it last time. -The database name is the same: "web"...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.