473,322 Members | 1,408 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,322 software developers and data experts.

backup from one server, restore to another

Hi there,

I've been sent a backup file from a SQL Server 2000 DB and tried
restoring into a blank DB (with the same name) on my SQL Server 2K,
only it errors, see below:
(I've separated each line with a return, to make it more readable)

2005-07-08 11:08:23.93 spid51 BackupIoRequest::WaitForIoCompletion:
read failure on backup device 'C:\file location to backup'. Operating
system error 87(The parameter is incorrect.).

2005-07-08 11:08:23.94 spid51 Internal I/O request 0x03BDFCEC: Op:
Read, pBuffer: 0x03BDF800, Size: 512, Position: 5136, UMS: Internal:
0x103, InternalHigh: 0x0, Offset: 0x1410, OffsetHigh: 0x0, m_buf:
0x03BDF800, m_len: 512, m_actualBytes: 0, m_errcode: 87, BackupFile:
C:\file location to backup

2005-07-08 11:08:23.94 spid51 The backup data in 'C:\file location
to backup' is incorrectly formatted. Backups cannot be appended, but
existing backup sets may still be usable.

2005-07-08 11:08:23.94 spid51 Starting up database 'databizDB'.

2005-07-08 11:08:24.02 spid51 Bypassing recovery for database
'databizDB' because it is marked IN LOAD.

2005-07-08 11:08:24.16 spid51 BackupMedium::ReportIoError: read
failure on backup device 'C:\file location to backup'. Operating system
error 87(The parameter is incorrect.).

2005-07-08 11:08:24.16 spid51 Internal I/O request 0x42FC5530: Op:
Read, pBuffer: 0x03980000, Size: 512, Position: 5648, UMS: Internal:
0x103, InternalHigh: 0x0, Offset: 0x1610, OffsetHigh: 0x0, m_buf:
0x03980000, m_len: 512, m_actualBytes: 0, m_errcode: 87, BackupFile:
C:\file location to backup

It may be something simple as I've never really got that involved with
this side of it before. Hopefully someone out there can shed some light
on it, please?

This may be normal, but I had to backup the blank DB locally first
before it would let me select a file to restore, so I could change the
location.

Cheers,
Rich.

Jul 23 '05 #1
4 10755
Be sure you have the CORRECT name next to 'Restore as database:' in
order for these steps to work:

When restoring the database, select the 'From device' radio button.
Then click 'Select Devices...' then click 'Add' then input the file
location and name. Click 'OK', 'OK' and then click on the 'Options' tab
and check 'Force restore over existing database'.

Under 'Restore database files as:' and 'Move to physical file name'
change those folders to the correct location. Click 'OK'.

You will be restoring over your blank database.

Jul 23 '05 #2
Hi joshsackett,

Thanks for the advice, I tried the Restore the way you suggested
(through 'From device') only I get the same error.

I'm starting to think that maybe the backup file I have is corrupt, as
I didn't do the original back, plus when I click on View Contents...
after selecting the file I get the following error. 'Error 3013:
RESTORE HEARDERONLY is terminating abnormally.'

I've defiantly got the right DB as I right click and select Restore.
I've even tried it on another SQL Server 2K, with the same results.

Can you think of anything else it might be?

Many thanks,
Rich.
joshsackett wrote:
Be sure you have the CORRECT name next to 'Restore as database:' in
order for these steps to work:

When restoring the database, select the 'From device' radio button.
Then click 'Select Devices...' then click 'Add' then input the file
location and name. Click 'OK', 'OK' and then click on the 'Options' tab
and check 'Force restore over existing database'.

Under 'Restore database files as:' and 'Move to physical file name'
change those folders to the correct location. Click 'OK'.

You will be restoring over your blank database.


Jul 23 '05 #3
Run this command from Query Analyzer:

RESTORE FILELISTONLY
FROM DISK = 'C:\BACKUPS\MyDb.BAK'

If you get an error then it is quite possible the database is
corrupted. Maybe it was backed up using a 3rd party application like
SQL LiteSpeed? In that case you'd need to have the same application on
your side to perform the restore.

Jul 23 '05 #4
Hi Josh,

Many thanks for that, it seems to have sorted it, plus I've also
installed Service Pack 3a.

Cheers,
Rich.

Jul 23 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Reuben Pearse | last post by:
Hi all, I've just converted the tables in a big database (approx 27 million records) from MyISAM to InnoDB. When I was using MyISAM I backed up the database by stopping MySQL and then copying...
1
by: Dave | last post by:
I am doing a complete backup on a sql 7 db and then doing a complete restore (with overwrite existing db) on a sql 2000 server. This is now our hot standby server. I have the process automated and...
2
by: acko bogicevic | last post by:
Hi everyone I have this situation with backup and restore. I have two instances of sql, sql1 and sql2. Production server is sql1 and test server is sql2. I created database maintenance plan...
1
by: gkucher | last post by:
If databases on a physical drive are fragmented, and the drive is extended by adding more hard drives to the array, does it make sense to backup and restore the fragmented databases? The...
3
by: Wojciech Jurek | last post by:
Hi! I need to backup database and then restore it from file on other computer. I'm using DB2 on Windows XP. Please give me two simple SQL statements which I could use in Command Centre. Thanks...
6
by: Tim Penhey | last post by:
Hi All, I have a java web server (Tomcat) running a web application that uses PostgreSQL for all of the data. All of the management of the application is done through the web application and I...
0
by: newman | last post by:
Dear all, I have mysql 4.1.11 on my current server, i need my database restore another server.. (another server mysql version is 4.1.11 same.) And now... I just created new my database to new...
5
by: smoi | last post by:
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...
1
by: ravish79 | last post by:
Can anyone tell me about database backup and restore. There are lot many dumps available but i want to use tar/gzip backup. also provide me information about restoring it in case of db crash. ...
0
by: raazju | last post by:
I've to backup and restore data into MS SQL Server database? I've to restore previous data into database server of MS SQL Server. anyone can help to solve this problem?
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
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...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
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.