Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
asp__developer
Posting Yak Master
108 Posts |
 Posted - 2013-01-14 : 12:03:10
|
| 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 - 2013-01-14 : 13:20:50
|
| anyone ? |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-01-15 : 00:47:34
|
| are you trying to restore on same server or onto different local server?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2013-01-15 : 08:36:56
|
| 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 |
|
|
|
asp__developer
Posting Yak Master
108 Posts |
Posted - 2013-01-15 : 15:56:40
|
| 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 ? |
|
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2013-01-15 : 18:46:23
|
| 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 |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2013-01-17 : 01:37:59
|
| 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 |
|
|
|
enjoydiablo3
Starting Member
4 Posts |
Posted - 2013-01-17 : 05:04:25
|
| unspammed |
|
|
|
|
|
|
unable to take backup & restore any database HELP