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 |
|
ttakou
Starting Member
2 Posts |
 Posted - 2014-04-08 : 20:16:51
|
| Dear all,when trying to restore my SQL Server database on SQL 2008 I got the error message Specify case not valid.I don't have any other backup file and this is my prod database. any ideas?actually the virtual server crashed and we were able to retrieved this database from the VM datastore after a lot of effort. |
|
|
ttakou
Starting Member
2 Posts |
Posted - 2014-04-09 : 01:24:32
|
| I decided to install SQL Server 2012 an when trying to restore the database from the backup I am now having the error message below"===================================Restore of database 'Glue' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks)------------------------------Program Location: at Microsoft.SqlServer.Management.RelationalEngineTasks.RestoreDatabaseTaskFormComponent.PerformTask(ITaskExecutionContext context) at Microsoft.SqlServer.Management.RelationalEngineTasks.RestoreDatabaseTaskFormComponent.Perform(ITaskExecutionContext context) at Microsoft.SqlServer.Management.TaskForms.TaskExecutionManager.ExecuteTaskSequence(ISfcScriptCollector collector)===================================System.Data.SqlClient.SqlError: The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Glue.mdf'. (Microsoft.SqlServer.SmoExtended)------------------------------For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=11.0.2100.60+((SQL11_RTM).120210-1917+)&LinkId=20476------------------------------Program Location: at Microsoft.SqlServer.Management.Smo.RestorePlan.Execute() at Microsoft.SqlServer.Management.RelationalEngineTasks.RestoreDatabaseTaskFormComponent.PerformTask(ITaskExecutionContext context)" |
 |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2014-04-16 : 19:06:05
|
| What version was the original database running on? You can restore an older version on a newer version but not the other way around. Also, SQL 2008 is considered older than SQL 2008R2.You also mentioned that you had to pull the database off of the VM Datastore. Are you using an actual backup file (*.BAK) and DATABASE RESTORE or are you using database files (*.MDF, *.NDF, *.LDF) and trying to ATTACH the database? Or is it something else completely...?===============================================================================“Everyone wants a better life: very few of us want to be better people.” -Alain de Botton |
|
|
|
|
|
|
Specify cast is not valid