How to create a backup device?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
How to create a backup device?
Rating:
Take the following steps to create a backup device:
- Run SQL Server Management Studio from Start > Programs > Microsoft SQL Server 2005 > SQL Server Management Studio.
- Right-click the Server Objects folder and go to New > Backup Device.
- In the Backup Device window, mention the device name and the destination file name. Click the OK button.
- Expand the Server Objects folder and the Backup Devices folder to see the backup device.
Rating:
Was this information helpful?
Other articles
- What are the types of capacity planning?
- What is SYS.DM_EXEC_QUERY_STATS DMV?
- Joins: Its Types and Uses
- What is a full backup?
- What is log shipping?