copy_only backup is used to take copy of full database backup with out breaking the squence of backup and restoed in msdb database.
syntex for copy_only backup
backup database my_db to disk 'd:\backup\my_db.bak ' with copy_only
above commend made a copy of full database with out stored information in msdb databse .
syntex for copy_only backup
backup database my_db to disk 'd:\backup\my_db.bak ' with copy_only
above commend made a copy of full database with out stored information in msdb databse .
No comments:
Post a Comment