Solved

Sql Server 2000 Restore Problems

Posted on 2009-04-11
11
296 Views
Last Modified: 2013-11-30
We run a sql database on a third party server. I regularly backup from the site and restore locally to run reports etc..Recently I tried this and Sql is telling me the backup file (.bak) is 'incorreclty formed'.

I am up to date on service packs and my 3rd party provider (1&1) advises me that the file is not corrupt in any way.

Any assistance greatly received. Bear in mind I am only an administarator not a developer/programmer so idiot speak please...
0
Comment
Question by:wh1neman
  • 4
  • 4
11 Comments
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 24121408
can you please show the exact/full error message, and the method you exactly you to restore, and how you do the backup?
0
 

Author Comment

by:wh1neman
ID: 24121903
I use the SQL Server enterprise manager to do my restores.  

Error message attached
ee-back.JPG
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24122188
You need to install the latest Service Pack for SQL Server 2000.

http://support.microsoft.com/kb/297104
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:wh1neman
ID: 24122270
Up to date on service packs
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24122698
I believe your Backup file is corrupted.

Are you sure that the Restore happened successfully and file not corrupted after that.
Kindly confirm that the Backup file is not corrupted by trying to restore in Another Server.
0
 

Author Comment

by:wh1neman
ID: 24122727
I have extracted further .bak files from our live database and they don't work either. I can restore earlier bakup files so something has changed in the recent bachups? Size?

My on-line service provider has successfully restored these files to the live database and has re-assred me the files are not corrupt.

Any other possibilities?
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24122741
Does the recent backups involve two Media File locations (means backing up a file into two *.bak instead of a single *.bak)

If it is tested out for Restoring in the same machine where it is backed up then it would take the files automatically and will work.

Try it in another machine to confirm it.
0
 

Accepted Solution

by:
wh1neman earned 0 total points
ID: 24150067
I think you misunderstand my issue - we are restoring locally from a third party database and there is only one file.

It turns out my service provider has updated to MSSQL 2008 and these .bak files are not backward compatible with our local MSSQL 2000 server.

We have had to upgrade our server which has presented other issues (posted as seperate question)
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24154554
Yes. Backups taken from SQL 2008 cannot be restored on to SQL Server 2000 directly.

To solve it out in a simpler manner, you have to upgrade the SQL Server 2000 in your machine to SQL Server 2008.
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SqlDataBase 7 48
get column names from table in vb.net 8 28
T-SQL: Do I need CLUSTERED here? 13 42
How to create a unique rule restriction on a table for two fields 16 81
Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question