how can create back up of database of SQL-Server

Question

how can create back up of database of SQL-Server.  explain process in detail

Answer 1

Check this link which gives more details about what si done when backup command is executed and how to take backup

http://www.sqlteam.com/article/backup-and-restore-in-sql-server-full-backups

---

Ramesh Babu Vavilla MCTS,MSBI

Answer 2

Please refer the below link:

http://technet.microsoft.com/en-us/library/ms186865.aspx

Answer 3

Hello,

With SMO, the topic of this forum? Or with SSMS UI? Or with Transact-SQL statement?

---

Olaf Helper

[ Blog] [ Xing] [ MVP]

Answer 4

Hello,

Please take a look at the following article regarding how to backup SQL Server database:
BACKUP (Transact-SQL): http://technet.microsoft.com/en-us/library/ms186865.aspx
SQL Server BACKUP DATABASE command: http://www.mssqltips.com/sqlservertutorial/20/sql-server-backup-database-command/

Furthermore, here are some best practices you can follow to ensure you have a good backup in place:

1. Make sure you are not storing your backups in the same physical location as the database files. When your physical drive goes bad, you should be able to use the other drive or remote location that stored the backups in order to perform a restore. Keep in mind that you could create several logical volumes or partitions from a same physical disk drive. Carefully study the disk partition and logical colume layouts before choosing a storage location for the backups.
2. Make sure you have a proper backup schedule established according to the needs of the application and business requirements. As the backups get old, the risk of data loss is higher unless you have a way to regenerate all the data till the point of failure.
3. Make sure to actually restore the backups on a test server and verify that you can restore with all the options and conditions you need to use during a planned or un-planned downtime.
4. Use the verification options provided by the backup utilities [BACKUP TSQL command, SQL Server Maintenance Plans, your backup software or solution, etc.
5. Use advanced features like BACKUP CHECKSUM to detect problems with the backup media itself.

Regards,

---

Elvis Long
TechNet Community Support

Answer 5

Hello ,

The Olaf's post was useful but has not been replied by the original poster (OP). It is why to propose a solution.

As the OP has posted in this forum , I may suppose that he/she wants a solution with SMO. Maybe these both links could be helpful :

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/06019826-ff58-4ffc-b685-502a9fa95f09/sql-server-database-back-up-in-c?forum=sqlsmoanddmo

http://msdn.microsoft.com/en-us/library/ms162133.aspx

this last link has the advantage to include code in VB and VC#

2nd solution : to use T-SQL to do a backup but it is not the good forum . In this case, a moderator will move this thread towards the Transact-SQL forum ( I could do it but I prefer to wait that the OP posts his agreement ).

Have a nice day

---

Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

Answer 6

For an example to backup a database with SMO see: Backing Up and Restoring Databases and Transaction Logs and Backup.SqlBackup Method

---

Olaf Helper

[ Blog] [ Xing] [ MVP]