subahan.munthamadugu (7/21/2013)
Hi all,please give command for "backup with norecovery" option.
Jeff gave a nice option but ill give another thought
right click database, select Backup, select backup type and try out different options and script it.
you have your script ready. MSSQL is a great friend.
Regards
Durai Nagarajan