SQL Server 2008 Backup

  • Hi Room,

    Can anyone advice and help on how to setup SQL Server 2008 backup best practice?

    I wanted to backup my SQL Server 2008 databases into Server_B D drive.

    I created a share folder "Server_B_Backup_Folder" and granted the security access.

    Thanks in advance.

    Edwin

  • What specifically do you want to know?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Hi Gail,

    I run into problems when I tried to setup the backup into

    "Server_B_Backup_Folder".

    The specific folder cannot be use or accessable..something like that..

    My backup plans:

    1. Full backup on Saturday at 1:00 AM

    2. Transaction Log backups on every 4 hours

    3. Differential backup on Monday, Wednesday, and Friday

    Please help and advise.

    Thanks,

    Edwin

  • If it can't access the folder, it's because of security. SQL Server runs under a different context than when you connect to it. Just because you can access the share doesn't mean the security context that the server is running under can. Find out what context SQL Server is running under and then verify that it has access.

    Also, it could just be a typo. Make sure you have everything defined correctly.

    ----------------------------------------------------
    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore Roosevelt
    The Scary DBA
    Author of: SQL Server 2022 Query Performance Tuning, 6th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

  • Hi..I figured it out. Thanks,

    Ediwn

  • Just so the next person along can understand, can you post the solution?

    ----------------------------------------------------
    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore Roosevelt
    The Scary DBA
    Author of: SQL Server 2022 Query Performance Tuning, 6th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

  • Just for interest, it's usually recommended that the backup be done to local disks and then copied to the network. Firstly because of the speed of local drives vs the speed of the network. Second because if there's a network glitch during the backup, the backup will fail.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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