February 17, 2010 at 2:25 am
YES!!
I confessed it crossed my mind whilest working on something else, but I dismissed it, as I didn't think that it would discriminate COPY_ONLY backups (I couldn't think of a valid reason why MS would want to do this). as someone may want to restore a COPY_ONLY backup to a test server ............
I guess I'm going to have to do some scripting then! 🙂
Thanks chaps
_____________________________________________________________________________MCITP: Business Intelligence Developer (2005)
February 17, 2010 at 8:57 am
Dave you can restore a copy only database backup using the GUI in SSMS. just do the following.
1. after clicking on restore database, select from device.
2. Click on the ellipis and then select add.
3. in the selected path put in the path where the backup file is located(\\servername\C$\folder)
4. in the file name put in the name of the backup file to be used. (file.bak)
February 18, 2010 at 3:05 am
Ok. So is this just a bug then - as I can't view the copy only backups when selecting a backup device?
_____________________________________________________________________________MCITP: Business Intelligence Developer (2005)
February 18, 2010 at 4:36 am
Apparently copy only backups are not supported or there have at least been reported bugs and issues in SSMS.
I got several hits on this issue yesterday before I knew that you were performing a copy only backup.
This is one article but if you Goggle you will get several depending upon the criteria that you specify:
http://bytes.com/topic/sql-server/answers/647716-sqlserver-2005-how-best-copy-one-database-another
I hope this helps but correct me if I'm wrong...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply