July 17, 2013 at 5:29 am
Hi
I have a SQL 2008 R2 enterprise edition compressedn backup which is to be restored on SQl 2008 R2 Standard edition. I see from MSDN that it can be done but how to do that? Will simple restore command work or there is difference in Restore command.
I did a RESTOR Verify only on Standard edition and it failed although passed on Enterprise edition.
Thanks
Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.
July 17, 2013 at 5:54 am
Other editions can read the compressed backup. It should work. Have you tried to restore ?
July 17, 2013 at 5:59 am
Yes, I tried. I got error: RESTORE HEADERONLY is terminated abnormally.
SQL Show (7/17/2013)
Other editions can read the compressed backup. It should work. Have you tried to restore ?
Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.
July 17, 2013 at 6:19 am
Probably more to that error message, care to post it in its entirety?
July 17, 2013 at 7:28 am
ok, I am attaching the error image..
Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.
July 17, 2013 at 7:41 am
does the sqlserver service account of your target server have the needed windows auth to read the backup file at the location you pointed to ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
July 17, 2013 at 7:49 am
S_Kumar_S (7/17/2013)
ok, I am attaching the error image..
Not enough information.
Run the restore from a T-SQL query window and post the complete output.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 17, 2013 at 9:50 am
In addition to the above, run this the below in the Query Analyzer and see which server instance you're actually restoring.
Select @@Version
Regards,
July 17, 2013 at 10:35 am
Have you confirmed your Standard Edition is 2008 R2 and not 2008? We ran into an issue based on that confusion yesterday.
Starting with 2008 R2, Standard Edition supports backup compression, and other editions, including SQLExpress R2, can restore compressed backups created on Enterprise Edition - I've done it.
July 18, 2013 at 7:37 am
Sorry, I couldn't follow yesterday. So Answering all questions in single reply:
Select @@Version (pls note only edition is different)
source : Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
destination:Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
does the sqlserver service account of your target server have the needed windows auth to read the backup file at the location you pointed to ?
Yes, the files are pasted locally first on destination and then being restored. And the folder where files are present is accessible by SQL Service account.
On running by TSQL , I get:
Msg 3203, Level 16, State 1, Line 1
Read on "C:\wwwroot\TM_ShoppingCache\GCMS.bak" failed: 13(The data is invalid.)
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.
July 18, 2013 at 9:04 pm
Possible that your bak file could be corrupted, can you verify the backup using the below query and post the result that appears.
RESTORE VERIFYONLY FROM DISK= 'X:\Yourfile.bak'
Regards,
July 19, 2013 at 12:51 am
Just my 2 ct.
You're still running SQL2008R2 RTM version.
Current is 2008 R2 Service Pack 2 ( and if you also do the CU it is on CU7 for sp2 )
Service packs and cumulative updates are there to fix issues !
and there have been a number of issues fixed. ( most important IMHO performance related )
There are also backup related fixes in there !
See if they can relate to your issue(s).
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply