Viewing 15 posts - 1 through 15 (of 15 total)
You should be able to use the CREATE DATABASE...FOR ATTACH syntax (see BOL). Or, you could do a backup/restore.
July 21, 2008 at 9:27 am
I wake up in the morning thinking the same thing as Jeff; but generally I spend the day replacing the curse words in my head with much nicer (though no...
July 18, 2008 at 8:50 am
For me the soft skills came from being a customer service professional (conference call operator), and working my way all the way up to Assistant Director of the department. After...
July 18, 2008 at 7:39 am
Since you didn't mention it in the original post...did you physically move the actual files to the new directory?
June 21, 2008 at 2:07 pm
Thanks Renato. We've rebooted these servers multiple times, to no avail. THanks Everyone; after talking to MS, looks like we may be trying a new domain account, to see if...
July 8, 2004 at 7:52 am
Doesn't look like my last post went through...Derrick, you might have something there. I'll be checking with our Exchange Admin on that. Although, our Dev servers use the same config...
July 6, 2004 at 10:46 pm
July 6, 2004 at 10:44 pm
Thanks for the replies. To answer:
I think the DLL theory is probably sound, if it weren't happening on more than one server (I forgot to include that in the original...
July 6, 2004 at 9:32 pm
That's becuase it's primarily used by SQL Server itself, in the administration of MSX/TSX jobs. I don't recall any specific links that'll help describe it better; I spent a lot...
October 3, 2003 at 3:06 pm
We're using SQLLiteSPeed 3.0 in our shop, and we've fallen in love with it in a matter of days. We've compressed our 198 GB database backups to 26.9 GB, and...
October 3, 2003 at 3:03 pm
In our environment, which is now entirely SQL 2K SP3, we were still able to use the TargetServerRole, with very few tweaks to it's permissions. Our objective was only to...
October 3, 2003 at 1:40 am
You have to move model first, then the msdb from the same server. Check KB article 224071, it has the instructions for 7.0/2K.
May 16, 2003 at 1:52 pm
Thanks Antares. I appreciate the notes. Hopefully, we'll get the SAN solution we are trying tp pitch.
May 6, 2003 at 7:42 am
In BOL, there is an entry concerning "Security Account Delegation". Search for it and you will find that this may be a fix you need to implement. Basically, it concerns...
May 5, 2003 at 10:17 pm
Thanks; we've been seriously considering that "motivational technique".
I know that the scenario described is a standard one; I just want to find out if there's any blazing potholes I...
May 5, 2003 at 10:06 pm