Backup without affecting LSN | SansSQL

Saturday, May 3, 2008

Backup without affecting LSN

/*In SQL server 2005 you can take backup without affecting logshipping . You can use WITH COPY_ONLY option in BACKUP command, this command will take backup without affecting LSN.*/
BACKUP DATABASE Yourdbname TO DISK='backup path' WITH COPY_ONLY
--Don't forget to change the dbname and backup path before using the above command.

Ads