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