May 13, 2010 at 9:42 am
Hi All,
I am going to perform an activity, need a confirmation is it fine to go or i have to make some amandments...
Senario :
I have to take backup from server A and restore it to server B and then i have to remove data from server A and provide almost new database on server A.
Plan :
first full backup from server A and restore it to server B.
2)I will stop live data or GSM communication with server A
and take a differential backup.
3)Restore differential backup on server B.
At this spot server A and server B will be alike...
now i have to work on server A.:-)
It is possible i just truncate 5 tables from server A and then can i restore only Differential backup on live server ?
is it possible ? or there is some flaw in planning ?
May 13, 2010 at 9:53 am
Live being server A or B?
If B, then yes, you can restore a diff providing the full backup was restored WITH NORECOVERY, leaving the DB offline and allowing for further restores (diff or log)
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
May 13, 2010 at 10:00 am
@ gilamonster
no i am talking abt A the live server.
it is clear to me regarding server B, how to proceeed.
i am asking CAN i Truncate some tables from server A and then can i restore Differential backup WITHOUT restoring Full backup ??
May 13, 2010 at 10:08 am
No.
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
May 13, 2010 at 10:14 am
ok so please tell me then what should i do ?
i dont have to keep any data on server A except the one that is in Differential backup.
if i go with Delete command with datetime column, this will be a long and time taking query...
i m having simple recovery model but many times i ffound Tlog get increases to quite a large size !!!
pls suggest what should i do ?
May 13, 2010 at 10:34 am
fawwad (5/13/2010)
ok so please tell me then what should i do ?
No idea, I don't understand what you're trying to do here. Maybe a bit more of an explanation of what is is that you're trying to do would help...
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
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply