Post reply

rename mdf and ldf

  • December 6, 2007 at 12:56 pm

    #177240

    We need to archive a db on a regular basis:

    rename to original to orig_history1 and start a new db with the original file names.

    Which is the best way to do this:

    I am thinking of:

    backup original db

    Restore as new db: change the file names during restore

    Drop and re-create the original.

    I could script this and give to apps administrator to run as and when they want to archive the db. They will have multiple history dbs and they are fine with this.

    thanks,

  • December 7, 2007 at 11:59 am

    #758200

    Are you asking us a question?

    Or do you want script?

    or Doyou looking for any other suggestion?

    Nita

  • December 7, 2007 at 1:20 pm

    #758211

    I am looking the best way to achieve this. I can script myself.

    Any better suggestions ?

Viewing 3 posts - 1 through 2 (of 2 total)

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