March 3, 2005 at 11:39 pm
sir ,how we use option 'NO RECOVERY' while performing database recovery.
March 4, 2005 at 12:13 am
I am not sure what is your problems exactly. If u r looking for an example here it is
RESTORE DATABASE MyNwind
FROM MyNwind_1
WITH NORECOVERY
My Blog:
March 4, 2005 at 2:39 am
Hi
1. When you recover database from one backup file, then this option is not required.
Restore database DBNAME from file
2. When you recover database from more than one backup file (1F , 1D, 4L) , then this option is required to tell the sql server that more backup is need to be restore, so don't bring the database to online
Restore database DNNAME from 1f with norecovery
Restore database DNNAME from 1D with norecovery
Restore database DNNAME from 1L with norecovery
Restore database DNNAME from 2L with norecovery
Restore database DNNAME from 3L with norecovery
Restore database DNNAME from 4L (No need to add norecovery, because this the last transaction log file restore to the database. Now sql server makes that database to online).
1F - Last Full Backup
1D - Last Differential backup after the Last FULL BACKUP
1T - 1 Transaction Log backup after the Last Differential BACKUP
2T - 2 Transaction Log backup after the Last Differential BACKUP
3T - 3 Transaction Log backup after the Last Differential BACKUP
4T - 4/ Last Transaction Log backup after the Last Differential BACKUP
With Regards
MeenakshiSundaram Lakshmanan
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply