Home Forums SQL Server 2008 SQL Server 2008 - General INeed to prepare a action plan by this requirement can any one send the information in a document fromat step by step IN very urgent basis. RE: INeed to prepare a action plan by this requirement can any one send the information in a document fromat step by step IN very urgent basis.

  • naga.rohitkumar (8/17/2012)


    I have to do my self but what is the process if a new drive is allocated for backups and datafiles how to move datafiles and backups into new drive

    i have to prepare a action plan before doing the activity so please guide if u can

    OK, that makes a little more sense. First things first, make sure you have monitoring in place to ensure you know when the drives are getting full. Plot this over time so you can project out to make semi-accurate estimates of when you need a new drive.

    Then it's like Gail says, for backups, you just have to change the location in your backup process and then validate that your backups are still working. Done. For the database files it's the commands she says, outline the steps. It's not hard. Write it all down. Organize it logically. Heck, when you get it all together, submit it as an article for Steve to publish here.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning