I couldn't restore the bak file

#1

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

#2

(yahya kemal kaya) writes:

Quote:

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 (AT) sommarskog (DOT) 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/prodinf...ons/books.mspx

#3

(yahya kemal kaya) writes:

Quote:

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 (AT) sommarskog (DOT) 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/prodinf...ons/books.mspx

#4

(yahya kemal kaya) writes:

Quote:

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 (AT) sommarskog (DOT) 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/prodinf...ons/books.mspx

#5

(yahya kemal kaya) writes:

Quote:

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 (AT) sommarskog (DOT) 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/prodinf...ons/books.mspx

#6

(yahya kemal kaya) writes:

Quote:

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 (AT) sommarskog (DOT) 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/prodinf...ons/books.mspx

#7

(yahya kemal kaya) writes:

Quote:

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 (AT) sommarskog (DOT) 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/prodinf...ons/books.mspx

#8

(yahya kemal kaya) writes:

Quote:

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 (AT) sommarskog (DOT) 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/prodinf...ons/books.mspx

#9

(yahya kemal kaya) writes:

Quote:

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 (AT) sommarskog (DOT) 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/prodinf...ons/books.mspx

#10

(yahya kemal kaya) writes:

Quote:

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 (AT) sommarskog (DOT) 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/prodinf...ons/books.mspx