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 ?
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?
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 ?
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
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?
unable to take backup & restore any database HELP
Posted - 01/14/2013 : 12:03:10
