Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

backup Expand / Collapse
Author
Message
Posted Thursday, November 26, 2009 7:19 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Thursday, November 26, 2009 7:42 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

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
Posted Thursday, November 26, 2009 7:48 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 11:23 AM
Points: 22,989, Visits: 31,464
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.



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
Posted Friday, November 27, 2009 5:06 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, June 20, 2014 8:19 AM
Points: 1,085, Visits: 272

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
Posted Friday, November 27, 2009 7:25 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld 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
Posted Friday, November 27, 2009 2:42 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, December 2, 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 »

Add to briefcase

Permissions Expand / Collapse