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