SQL Server Performance

back up issue

Discussion in 'General DBA Questions' started by contactjimmyus, Apr 17, 2009.

  1. Our one production db is 48 gb and it takes more than an hour to take back up .We are thinking to reduce the back up time .The data files are on san drives and the back up too is going to the san drive .The temp db also is on the san and is on the same drive as data drive
    Does temp db is involved in backup operation of other db if so moving the temp db to other directory can improve performance ?
    ANY suggestions ?
  2. Adding a bit more info about the server and the database .
    The server has four drives C lOCAL drive ,D ,E san drive and is Raid 1 Configuration .Drive F is from san and is Raid 5 configuration.
    The database has three file group ie primary(system tables) ,all the tables are in secondary file group and all the indexes are in another file group (All in D Drive )All file groups have only one file .The log file is in E drive .The temp DB data and log are configured on E drive .The back up is scheduled to take back up on F drive.The server has 25 GB ram.
  3. satya Moderator

    What is the exact data file size (occupied)?
    As the backup consists the complete database size including the transaction, it is better to perform transaction log backup regularly and take overnight backup to ensure it can be completed quickly.
  4. jennyya New Member

    It seems that you can work without the usage of backup copies. the utility of repair sql server database sbd sml files can quickly open damaged databases if necessary and upload the source data to your database servers. I think it is the easiest solution.Jenny
  5. satya Moderator

    Jennyya
    I believe you have posted similar text on other forum thread as well, please refrain posting such advertising material on technical related posts. If you are willing to get a review of your software/tool please contact webmaster of this site for more information.

Share This Page