• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 309
  • Last Modified:

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...
0
wh1neman
Asked:
wh1neman
  • 4
  • 4
1 Solution
 
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
 
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
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
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
 
wh1nemanAuthor 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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now