Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

I couldn't restore the bak file

 
   Database Help (Home) -> Tools RSS
Next:  Run time insert/update in stored procedure from C..  
Author Message
yahya kemal kaya

External


Since: Jan 01, 2009
Posts: 1



(Msg. 1) Posted: Thu Jan 01, 2009 4:21 am
Post subject: I couldn't restore the bak file
Archived from groups: microsoft>public>sqlserver>tools (more info?)

First of all happy new year to all.
I could not restore the bak file to sql server 2000. i rescued the bak files from a formatted hard drive. Now i want to restore it to the sql server but i can't do it. there is a message like this "it doesn't a sql backup file that you want to restore". Please help me.
Thanks..

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com

 >> Stay informed about: I couldn't restore the bak file 
Back to top
Login to vote
Erland Sommarskog2

External


Since: May 30, 2004
Posts: 2061



(Msg. 2) Posted: Thu Jan 01, 2009 5:21 am
Post subject: Re: I couldn't restore the bak file [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

(yahya kemal kaya) writes:
> First of all happy new year to all.
> I could not restore the bak file to sql server 2000. i rescued the bak
> files from a formatted hard drive. Now i want to restore it to the sql
> server but i can't do it. there is a message like this "it doesn't a sql
> backup file that you want to restore". Please help me.

What is the exact error message? Or is that a translation from your
localised version of SQL Server?

It seems that either your backup file is damaged, or you have gotten hold
of a completely different file that you intended. It was a backup from
SQL 2000, you thought you had, wasn't it?

I'm afraid that there is not much help you can get here with the amount
of information you have provided.


--
Erland Sommarskog, SQL Server MVP, esquel.DeleteThis@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

 >> Stay informed about: I couldn't restore the bak file 
Back to top
Login to vote
Ekrem_Önsoy

External


Since: Jan 11, 2008
Posts: 267



(Msg. 3) Posted: Thu Jan 01, 2009 1:25 pm
Post subject: Re: I couldn't restore the bak file [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Also, you can't restore a SQL Server 2005 backup file to a SQL Server 2000
Instance so ensure that the backup file is backed up from a SQL Server 2000
Instance.

As Erland mentioned, you need to provide more specific info about the error.

--
Ekrem Önsoy



"yahya kemal kaya" wrote in message ...
> First of all happy new year to all.
> I could not restore the bak file to sql server 2000. i rescued the bak
> files from a formatted hard drive. Now i want to restore it to the sql
> server but i can't do it. there is a message like this "it doesn't a sql
> backup file that you want to restore". Please help me.
> Thanks..
>
> EggHeadCafe - .NET Developer Portal of Choice
> http://www.eggheadcafe.com
 >> Stay informed about: I couldn't restore the bak file 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
sql server 2005 database in restore mode - Hi folks I was restoring a database in SQL Server 2005 express edition. Due to a malfunction, system restarted. Now when I try to access the database, the status shows as "Restoring Database". I have tried to restart SQL Server and PC, but ...

restore sql 2000 backup.bak to sql 2005 database fail - Any one konw the step how to restore sql 2000 database to sql 2005 i got error when i restore backup.bak(backup from sql 2000) file to sql 2005 i right click then choose task , restore

Katmai - is this a Help file - Is Katmai help file?

Exporting ToExcel file - Hi, I have a SP that adds an Excel file as a linked server, then tries to send the result of a query into this file. I get the following error : ------------ OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. Authentication failed. Insert..

Corrupt LDF file - I am looking for any tools capeable of repairing or recover data from a corrupt (LDF) log file. I have a situation where my mdf and ldf files were damaged after a hard drive failure. I was able to recover data from the damaged (mdf) data file however....
   Database Help (Home) -> Tools All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]