backup

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

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


    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

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

  • 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

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

  • 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