Post reply

backup

  • November 26, 2009 at 7:19 pm

    #214185

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

  • November 26, 2009 at 7:43 pm

    #1084748

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

    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

  • November 26, 2009 at 7:48 pm

    #1084750

    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.

  • November 27, 2009 at 5:06 am

    #1084863

    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

  • November 27, 2009 at 7:25 am

    #1084913

    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.

  • November 27, 2009 at 2:42 pm

    #1085040

    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[/url]

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

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply