![]() To access this, right-click the server name in Object Explorer and select Properties then click the Database Settings page of the Server Properties dialog box. The default value for backup expiration is the value set in the Default backup media retention (in days) option. This value can be from 0 to 99999 days a value of 0 days means that the backup set will never expire. Specify the number of days that must elapse before this backup set expires and can be overwritten. This option is disabled if URL is chosen as the backup destination. The system automatically suggests a default name based on the database name and the backup type.įor information about backup sets, see Media Sets, Media Families, and Backup Sets (SQL Server).Ĭhoose one of the following expiration options. ![]() The options of the Backup set panel allow for you to specify optional information about the backup set created by the back up operation. When you specify a backup task by using SQL Server Management Studio, you can generate the corresponding Transact-SQL BACKUP script by clicking the Script button and then selecting a destination for the script.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |