Sql Server 2000 Restore Problems

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...
wh1nemanAsked:
Who is Participating?
 
wh1nemanConnect With a Mentor Author Commented:
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
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
can you please show the exact/full error message, and the method you exactly you to restore, and how you do the backup?
0
 
wh1nemanAuthor Commented:
I use the SQL Server enterprise manager to do my restores.  

Error message attached
ee-back.JPG
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
Raja Jegan RSQL Server DBA & ArchitectCommented:
You need to install the latest Service Pack for SQL Server 2000.

http://support.microsoft.com/kb/297104
0
 
wh1nemanAuthor Commented:
Up to date on service packs
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
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
 
wh1nemanAuthor Commented:
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
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
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
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
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
All Courses

From novice to tech pro — start learning today.