backup

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Backups » backup

backup

Rate Topic

Display Mode

Topic Options

Author

Message

desai-1070753

Posted Thursday, November 26, 2009 7:19 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, November 30, 2009 5:55 AM
Points: 1, Visits: 12

can any one explain T-sql script for backing up database

Post #825401

Bru Medishetty

Posted Thursday, November 26, 2009 7:42 PM

SSCommitted

Group: General Forum Members
Last Login: Monday, February 11, 2013 8:27 AM
Points: 1,735, Visits: 1,947

SQL Books Online gives a very good explanation. Please refer it.

Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.com\LearnSQLWithBru

Twitter -- BruMedishetty

Post #825403

Lynn Pettis

Posted Thursday, November 26, 2009 7:48 PM

SSC-Insane

Group: General Forum Members
Last Login: Today @ 7:21 PM
Points: 21,832, Visits: 27,853

For 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.

Cool

Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)

Post #825405

Tim Reddish

Posted Friday, November 27, 2009 5:06 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, June 06, 2013 5:27 AM
Points: 1,085, Visits: 209

See 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.htm

Post #825559

Ritesh Medhe

Posted Friday, November 27, 2009 7:25 AM

Old Hand

Group: General Forum Members
Last Login: Wednesday, July 18, 2012 1:22 AM
Points: 325, Visits: 234

you 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.

Post #825619

support.sql

Posted Friday, November 27, 2009 2:42 PM

Valued Member

Group: General Forum Members
Last Login: Wednesday, December 02, 2009 2:07 PM
Points: 70, Visits: 32

Here is good tutorial about backups.

http://www.exforsys.com/tutorials/sql-server-2005/sql-server-database-backup.html

Regards

SNM

Try Free Microsoft SQL Server Data Collector & Performance Monitor.

http://www.analyticsperformance.com

@nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector

Post #825761

« Prev Topic | Next Topic »

Permissions