473,703 Members | 2,675 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 ::WaitForIoComp letion:
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::R eportIoError: 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 10792
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\MyD b.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
11418
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 the MYI, MYD, frm files in the database directory, and restored the database in the same way. Is there a similar way to backup and restore InnoDB tables, or do I have to use the InnoDB Hot Backup tool?
1
5902
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 it works great. The only problem I have now is the logins dont work. I have tried running EXEC sp_change_users_login 'Report', and the logins appear. However, when I run EXEC sp_helplogins 'joe', the results are empty. So, I am guessing all...
2
1478
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 that makes full backup every night on tape. I would like to make some kind of job or to add steps to job that was created with DMplan which will make restore of backuped database to sql2
1
2274
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 Windows Server should be able to find contiguous space for each database, since it shows 75% free space on the SQL Data drive without any file fragments on it. Or will it restore to the original location, in which case does it make sense to delete...
3
1966
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 in advance Wojtek
6
3012
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 would like to provide a backup and restore option for the user. Backup would somehow get all of the data/schema (maybe not schema) from the DB and zip it and send it to the customer through the web-app to allow them to save the backup on their...
0
1894
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 server following command: CREATE DATABASE dbname DEFAULT CHARACTER SET latin5 COLLATE
5
7108
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 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...
1
5076
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. Method i use should be easy and fast. From C# as front end in linux server I should be able to do this. I will be more happy if somebody helps me on this scenario.
0
1146
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
8660
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9240
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
8998
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8955
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
5922
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4675
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3113
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2430
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2056
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.