Post reply

SQL Server backup scripts

  • September 23, 2009 at 8:20 am

    #211396

    I am using SQL server 2005. I need some script that will do transactional backup every 2 hrs, differential backup every 6 hs and Full backup 2 times in a week. does any body have a script like that. or something similar will also be helpful.

    Thanks

  • September 23, 2009 at 8:22 am

    #1057546

    and yes if if the script first create a folder by date every day.

  • September 23, 2009 at 8:42 am

    #1057562

    any help is appreciated friends.............

  • September 23, 2009 at 8:53 am

    #1057568

    You dont want much do you...

    You havent mentioned if this is for a single database or for all the user databases on the server.

    This is an example of a script that is on this site

    http://www.sqlservercentral.com/scripts/Backup+%2F+Restore/31932/

    or this for another example

    http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/62380/

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • September 23, 2009 at 9:03 am

    #1057576

    actually i have more than one databases............

  • September 23, 2009 at 9:06 am

    #1057581

    have a look at the links that I gave to to you in my precious post, they should help you with your query.

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • September 23, 2009 at 9:11 am

    #1057583

    thanks a lot.

  • September 23, 2009 at 9:36 am

    #1057599

    But instead of coping over to server and then moving on the network path, is there anything to direct take a bak on the network path.

  • September 23, 2009 at 11:25 am

    #1057669

    Of course you can do it:

    BACKUP DATABASE MyDatabase TO DISK = '\\myserver\myshare\MyDatabase.bak' WITH INIT

    Do not forget to provide the folder level permissions on a shared folder (myshare in my example) and to share this folder for your SQL Agent account.

  • September 24, 2009 at 3:52 am

    #1057921

    Hi

    My "limited" experience of network backups are they work fine if the db is small but larger db's might have issues. We had a 75Gb db which 1 of the DBAs here initially set up to do a full network backup and it consistently fell over. To counter this and ensure we always had a recent backup we set up a local backup and then a copy across to the network location which then deleted the local bak file on successful copy.

    Obviously depends on the infrastructure capacity as well tho.

    KG

Viewing 10 posts - 1 through 9 (of 9 total)

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