change mdf and ldf files

Question

Post reply

change mdf and ldf files

Denise McMillan

SSCertifiable

Points: 6216
More actions
September 19, 2005 at 12:26 pm

#165987

If I want to change mdf and ldf files that a database uses should I:
detach database, get rid the old mdf and ldf files, put the mdf and ldf that I want to use in the place of the old ones and then attach the database?
Or is there a more correct way to do this?
Thanks!

Viewing 9 posts - 1 through 8 (of 8 total)

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

noeld SSC Guru Points: 96590 More actions · Answer 1

noeld

SSC Guru

Points: 96590

September 19, 2005 at 12:53 pm

#591085

are talking about a Restore?

* Noel

Denise McMillan SSCertifiable Points: 6216 More actions · Answer 2

Not exactly, we copied the mdf&ldf files (used detach/attach), sent them to our vendor, they updated them and sent them back. So I just detached the database, renamed the old mdf&ldf, them moved the updated mdf&ldf into their place and attached the database.

Is this ok, or is there more involved? Thanks very much.

noeld SSC Guru Points: 96590 More actions · Answer 3

noeld

SSC Guru

Points: 96590

September 19, 2005 at 1:06 pm

#591093

Perfectly Ok!

* Noel

AJ Ahrens SSC-Insane Points: 20676 More actions · Answer 4

In addition to Noel's response: Is there data involved? Is this Production? Is this acceptable from your IS security team's persepective? Was this checked to ensure that virus/worms/other nasty stuff was not "awakened" when the vendor database would be brought on-line?

What we do here is have the vendor send us the scripts to make the changes and then review and apply the changes.

Good Hunting!

AJ Ahrens

webmaster@kritter.net

Denise McMillan SSCertifiable Points: 6216 More actions · Answer 5

Thanks for your responses. It worked well. I appreciate the security concerns. If/when we have to work this way with a vendor, how can we check the files for viruses/worms? Thanks again.

noeld SSC Guru Points: 96590 More actions · Answer 6

Denise,

I have to admit this is very unconventional (sending the mdf/ldf to the vendor) but if on top of that you are expecting viruses from them I think you have bigger problems.

By the way you can use any antivirus software to scan those files.

* Noel

Denise McMillan SSCertifiable Points: 6216 More actions · Answer 7

I'm not expecting viruses, I trust our vendors. I was just addressing the previous response. Thanks again for your help.

Rudyx - the Doctor SSC-Forever Points: 43695 More actions · Answer 8

Noeld, we've actually had to perform a conversion in this manner just recently. A third party product chose by the user community (with no IS input at all !) caused conversion headaches (it just flat out did not work !). So we were reconciled to the fact that we had to detach the database and ftp the mdf/ldf files for conversion. Then we just had to ftp the resulting mdf/ldf files back when they were through (1 week later !).

RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."