The database's log file had jacked up to the near max on the share that was established for the ldf's (it...

Hi Gail! 😀

I honestly had never seen it do that before when restarting the service. The thing was there was a large import of data going on to...

Whew! Nevermind! IT just came back. Now - I pray there is not torn page corruption!

:w00t:

Tried this script on a 2005 SP3 system, to try and construct insert statements for a rather large table of data (hundreds of millions of rows). Needless to say...

Hi Jack - thank you (and all of you) for your input on this. I appreciate it, and apologize if I came off at all in an unappreciative way....

I just received some information from one of my colleagues that is looking at the ID skips with me, and he has indicated that he does not believe that Jack's...

Jack, thank you for the response. The new system is still on SQL 2005, but will be Enterprise Edition instead of Standard Edition. Also - I am trying...

Kraig, thank you for sharing this. I'm sure my guys who are working on this are going to be thrilled!

😛

Hi again Kraig...He basically described the following...

"Basically trying figure out the pitfalls when working with four nonproduction environments and managing changes..."

If this leads down too many Rabbit holes, just let...

Hi Kraig - This is more research that I am doing for a colleague. He may give me some details to share, or just jump right in here in...

It's never a good idea with today's Registry intensive applications to move an install from one drive to another. That being said, what you may want to consider is...

When did this become the South African Recipe thread?!?

😛

Adam Durr (9/2/2011)

---

I have had to do an install from hard disk before. You can try these steps, but they are from SQL 2005. This should still be relevant though.

http://support.microsoft.com/kb/916760

Just...

Jared, thank you! This is precisely what I was looking for.

P.S. Jeff - I agree with you on Michaels take on how to handle it moving forward (along with everyone's ideas).