how to take copy only backup in sql server
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