InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 22:00:49 GMT20http://www.sqlservercentral.com/Forums/Topic825401-357-1.aspxHere is good tutorial about backups.http://www.exforsys.com/tutorials/sql-server-2005/sql-server-database-backup.htmlRegardsFri, 27 Nov 2009 14:42:56 GMTsupport.sqlhttp://www.sqlservercentral.com/Forums/Topic825401-357-1.aspxyou definatley need to read BOL, however i guess you must be beginner so if you dont want to get confused with syntax in bol, refer the below code backup database test_database to disk = 'D:\test_database.bak'test_database is the name of the database.'D:\test_database.bak' is the location on server where the backup file will be created.This is the vanila code to do full database backup.Fri, 27 Nov 2009 07:25:24 GMTRitesh Medhehttp://www.sqlservercentral.com/Forums/Topic825401-357-1.aspxSee the following for information about the BACKUP T-SQL command:ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/89a4658a-62f1-4289-8982-f072229720a1.htmFri, 27 Nov 2009 05:06:40 GMTTim Reddishhttp://www.sqlservercentral.com/Forums/Topic825401-357-1.aspxFor general information regarding BACKUP and RESTORE I'd start by reading BOL (Books Online, the SQL Server Help System). Your question is really quite open and I'm not really sure what you are trying to ask.Thu, 26 Nov 2009 19:48:40 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic825401-357-1.aspxSQL Books Online gives a very good explanation. Please refer it.Thu, 26 Nov 2009 19:42:59 GMTBru Medishettyhttp://www.sqlservercentral.com/Forums/Topic825401-357-1.aspxcan any one explain T-sql script for backing up databaseThu, 26 Nov 2009 19:19:57 GMTdesai-1070753