Thursday, March 8, 2012

Can't Restore a DB backed up with COPY_ONLY in Mgmt Studio

If I create a backup using the following T-SQL, is there a specific reason that I cannot restore it through Mangement Studio.

BACKUP DATABASE MyDB

TO DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\MyDB_1.BAK'

WITH FORMAT, COPY_ONLY, NAME = 'Backup of MyDB'

I can still restore it using T-SQL but would like the conveinence of using Managment Studio. Any ideas? Is this a bug or is this by design? If by design, what would be the reason?

Any help is appreciated.

Are there any ideas on this one?|||SQL Server Management Studio does not support copy-only backups, as per BOL notes.

No comments:

Post a Comment