SQL Server - I couldn't restore the bak file
Asked By yahya kemal kaya
01-Jan-09 07:21 AM
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..
SQL Server 2005
(1)
SQL Server 2000
(1)
SQL Server
(1)
Translation
(1)
Backup
(1)
Ekrem
(1)
Önsoy
(1)
Kaya
(1)
Erland Sommarskog replied...
(yahya kemal kaya) writes:
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@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
ekre replied...
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
SQL Server MSDE on Windows 2003 R2 box, new DL385G6 - Install Fails during SQL Services I have been finding that I am having trouble with the Crystal Reports Server XI installation failing when it is dealing with SQL. So, as a thought and in case there was something wrong with my SQL portion of the isntall. I thought ok, I will try installing the actual MSDE application direct from Microsoft. So, I downloaded the MSDE for SQL 2000 (which is msde2000a.exe), set my switches and off to the races. It quit when
SQL Server unable to connect to sql server remotely This is a multi-part message in MIME format. - -- -- - = _NextPart_000_0006_01C831AE.4FC2B4D0 Content-Type: text charset = "iso-8859-1" Content-Transfer-Encoding: quoted-printable Here is my issue. I installed SQL 2005 on one of my servers. Up until 10 = minutes ago I was able to connect to the server remotely using SQL = Server Management Studio but I was unable connect to the SQL server from = the actual
SQL Server Backup Error Message Hi, Im trying to capture the error message that is thrown while backup. BACKUP DATABASE TestPradDB TO DISK = 'D: \ SQL \ Backup \ TestPradDB_20080213_Full.bak' I get the below msg when I try to back up my DB Msg 3202, Level 16, State 2, Line 1 Write on "D: \ SQL \ Backup \ TestPradDB_20080213_Full.bak" failed: 112(There is not enough space on the disk.) Msg 3013
SQL Server Reservered Words Is there a link available for reservered words Can a field be named ISO words when I get home. It is pre3tty long. Someone else will have a SQL Server list, I am sure. http: / / msdn.microsoft.com / en-us / library / aa238507(SQL.80).aspx Yes, GROUP is reserved keyword. Here is the list: http: / / msdn.microsoft.com select [GROUP] from #t; it is legal, but do not do it. Reserved word lists: SQL 2008 http: / / msdn.microsoft.com / en-us / library / ms189822.aspx SQL 2005 http: / / msdn.microsoft.com / en-us / library / ms189822%28SQL.90%29.aspx SQL 2000 http: / / msdn.microsoft