Problem How can I manually backup and restore a ClockWork Sql Server database?
• Launch the Sql Server Management Studio (Start-All Programs-Microsoft Sql Server 2005-Sql Server Management Studio), and connect. • Expand the “Databases” node and right-click on the database you would like to backup. • Select “Tasks-Backup…”. • In the “Destinations” section at the bottom, use the “Add” button to add a path and filename to the list (click “remove” to remove any items that are in the list by default). • Click the “OK” button Manually backing up a Sql Server 2000 database using DbaMgr2K • Launch ‘DbaMgr2K’ (Start-All programs-DbaMgr2k-DbaMgr2k). • There is a column on the left that has a single item in it called “Sql Server” – double-click on the words “Sql Server”. • Click the ‘connect’ button • Find the database called “Kioskxxx” in the left column and left-click once to select it • Right-click on “Kioskxxx” (where you just clicked on to select) and choose “Backup database” • At the bottom of the dialog that appears there is a section called “Destination disk” – if
