Smart Software – Microsoft SQL Server Express (Backup)

Smart Software can use few types of backup tools for backup the database. Previously, we had show the steps using DbaMGR2K to backup. 

Therefore for this session, we will shows how to backup using another tools which is Microsoft SQL Server Express. Below is the steps:

1) Click Microsoft SQL Server 2005 –> SQL Server Management  
     Studio Express.
2) On Authentication area  select Windows Authentication.
      Click Connect –> Double click the Database folder.
3) Click at the Database required for backup –> Right Click –> 
     Tasks –> Backup.
4) At Destination Disk –> Click Add –> File Name –> Click ..
     choose the backup location and name the backup file.
     Remember after the file name put the .bak –> Click OK
5) Click OK –> Click OK.
      The backup process will start, after finish Click OK. Then come 
      out from the screen. (The backup database is done.) User can
      keep extra copy to their pen-drive or external hard disk.

For more enquiry please contact us 03-91722228 or visit our website at www.smart-bizsolution.com