Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
SQL server does nor really have an online/offline backup.
However if you stop SAP and perform a backup, you have an offline backup.
Do not change the system to simple mode and you can restore the transaction logs to a point-in-time.
Regards
Sent from my Windows Phone
| | | ---------------Original Message---------------
From: Velayutham
Sent: Thursday, June 23, 2011 12:17 AM
Subject: ECC PRD to QAS by backup/restore in mssql2005+windows2003
Dear Guys
Am gonna do a backup/restore method from PRD to QAS. because our QAS doesn't have new data to test. Current src & trg syst is
source = ECC6 PRD [SP level 19 & kernal level 185] + win2003 sp2 + mssql2005 sp2
target = ECC6 PRD [SP level 19 & kernal level 185] + win2003 sp1 + mssql2005 sp1
quest is -
1.can i take backup frm src & restore directly to trg OR i have to apply the SP's of win & mssql to trg & then restore?
2.my backup of mssql is going to be night backup, so no user would be logged and am gonna take simple recovery mode with full, so two files will get backup; .MDF & .LDF, other than this any other files necessary to restore
3.if restore is success, what is the next step,i mean how to log into ECC6 syst and other steps.
Please help me in this. |
| __.____._ Copyright © 2011 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| |  D. Caddick
SAP Basis Top Contributor
Contributed the most posts in a group for 3 consecutive months to earn a Gold Achievement Popular White Papers
In the Spotlight  _.____.__ |
