SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 unable to take backup & restore any database HELP
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

asp__developer
Posting Yak Master

108 Posts

Posted - 01/14/2013 :  12:03:10  Show Profile  Reply with Quote
I have installed SQL Server 2012 express (management studio) on windows 7 - I am the primary user to basically I am the admin on the machine.

Whenever I try to take any backup (bak file), create sql script or restore any bak file to a new database - I am unable to do that..all the back file or sql scripts created on my machine are created fine without any error but when I try to restore that database or script on other machines - I get error that the database file is not is not a proper database file.

What could be the issue ? I even tried connecting / login using sa username - Is it something to do with permission that whatever backup or sql script for data I create - the data is not being rendered because of permission issue ?

asp__developer
Posting Yak Master

108 Posts

Posted - 01/14/2013 :  13:20:50  Show Profile  Reply with Quote
anyone ?
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 01/15/2013 :  00:47:34  Show Profile  Reply with Quote
are you trying to restore on same server or onto different local server?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2011 Posts

Posted - 01/15/2013 :  08:36:56  Show Profile  Visit jackv's Homepage  Reply with Quote
are the other machines running the same version of SQL server or older ?
have you confirmed the sql server start up account on the other server has relevant permissions to the .BAK file?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

asp__developer
Posting Yak Master

108 Posts

Posted - 01/15/2013 :  15:56:40  Show Profile  Reply with Quote
I have tried restoring the bak file (generated on my mcahine) on my machine itself in a blank database as well as different machines.

I am using SQL Server 2012 but other machines are using old versions like 2005 and 2008 but when I create sql script on my machine using 2012 I select 2005 for output so it should run - my hosting company tried restoring the bak file I provided them (created on my machine using 2012) - they said there is no data..

While Creating bak file - i am assuming it should restored on any version of sql server as while creating bak file we don't get option like while creating sql script to select the destination vesion ?
Go to Top of Page

Bustaz Kool
Flowing Fount of Yak Knowledge

USA
1645 Posts

Posted - 01/15/2013 :  18:46:23  Show Profile  Reply with Quote
The general rule for restoring backups is that you can restore old versions (e.g.2005) on new vewrsions (e.g., 2008) but you cannot restore new versions on old versions. So when you make a backup on a 2012 server, you cannot restore it on an earlier version.

=================================================
Tact is the ability to describe others as they see themselves. -Abraham Lincoln
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2011 Posts

Posted - 01/17/2013 :  01:37:59  Show Profile  Visit jackv's Homepage  Reply with Quote
To confirm (partly) the issue the hosting company , use RESTORE VERIFY ONLY on the .bak file. It will confirm :1) backup set is present and header fields of pages 2) Are volumes readable?



Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

enjoydiablo3
Starting Member

4 Posts

Posted - 01/17/2013 :  05:04:25  Show Profile  Reply with Quote
unspammed
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000