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.
Joshua Jones
Director, Global Database Services
PGi
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...
Joshua Jones
Director, Global Database Services
PGi
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...
Joshua Jones
Director, Global Database Services
PGi
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?
Joshua Jones
Director, Global Database Services
PGi
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...
Joshua Jones
Director, Global Database Services
PGi
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...
Joshua Jones
Director, Global Database Services
PGi
July 6, 2004 at 10:46 pm
Derrick,
Joshua Jones
Director, Global Database Services
PGi
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...
Joshua Jones
Director, Global Database Services
PGi
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...
Joshua Jones
Director, Global Database Services
PGi
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...
Joshua Jones
Director, Global Database Services
PGi
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...
Joshua Jones
Director, Global Database Services
PGi
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.
Joshua Jones
Director, Global Database Services
PGi
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.
Joshua Jones
Director, Global Database Services
PGi
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...
Joshua Jones
Director, Global Database Services
PGi
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...
Joshua Jones
Director, Global Database Services
PGi
May 5, 2003 at 10:06 pm
Viewing 15 posts - 1 through 15 (of 15 total)