Post reply

Full and trans on same device

  • June 17, 2008 at 2:12 pm

    #189266

    is it ok to have full and transactional backup on same device?

    or would you guys recommend seperate disk device for each

    thx

  • June 17, 2008 at 3:25 pm

    #830085

    I don't use devices ever.

    I want separate files for every backup. If you have 2 or more backups on a single device or file and something happens, you could lose a lot of data.

    If you want devices, do not mix full and logs. Same reasons. Use a separate device for each.

  • June 17, 2008 at 3:40 pm

    #830097

    ok thx

  • June 18, 2008 at 2:41 am

    #830260

    You could use it on the same device provided you have a mechanism to backup those files onto tape drives. In my company, this is the process being following that too for production databases.

    Thanks.

    M&M

  • June 18, 2008 at 7:29 am

    #830402

    Denby (6/17/2008)

    is it ok to have full and transactional backup on same device?

    or would you guys recommend seperate disk device for each

    thx

    I would suggest it's depend on the organization and DBA, how they wana implement the DB structure. If there is no issues then I would recommand you to go with seprate Drive. If not you can use the same drive but make sure withdiff. folders. Again It's upto organization and You.

    Manoj

    MCP, MCTS (GDBA/EDA)

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

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