Viewing 15 posts - 271 through 285 (of 619 total)
C'mon people, somebody must've seen this berfore?
Steve, Gail, Lyn any ideas?
Adam Zacks-------------------------------------------Be Nice, Or Leave
May 4, 2010 at 6:12 am
bryan van ritter (5/3/2010)
Hi Adam,maybe these links will help you on the way:
http://msdn.microsoft.com/en-us/library/ms190488.aspx
http://msdn.microsoft.com/en-us/library/ms189493.aspx
Bryan
Thanks Bryan, but I am more interested in why i am seeing a shrink db command for...
Adam Zacks-------------------------------------------Be Nice, Or Leave
May 3, 2010 at 3:41 am
Suresh B. (4/30/2010)
On a single server, mirroring works between two instances.
Agree.
Mirroring has to (as far as i am aware) go from one database, to another of the same name....
Adam Zacks-------------------------------------------Be Nice, Or Leave
April 30, 2010 at 4:08 am
mbricker-600840 (4/28/2010)
Lugubrious
Sad 🙁
Try this:
Acrimoniously
Adam Zacks-------------------------------------------Be Nice, Or Leave
April 28, 2010 at 6:53 am
Jpotucek (4/26/2010)
Do you know how I check my Windows Regional settings: or do I need to engage my Server guys?
You would check the same way you would in XP,...
Adam Zacks-------------------------------------------Be Nice, Or Leave
April 26, 2010 at 6:48 am
No probs 🙂
Adam Zacks-------------------------------------------Be Nice, Or Leave
April 26, 2010 at 4:55 am
I have never actually performed an upgrade from 2k5 to 2k8 but i would imagine so. Any db's in 2k comp mode would also be left as they are. {assumption...
Adam Zacks-------------------------------------------Be Nice, Or Leave
April 26, 2010 at 4:27 am
Suresh B. (4/26/2010)
Timothy.Cloud (4/23/2010)
Adam Zacks-------------------------------------------Be Nice, Or Leave
April 26, 2010 at 3:53 am
If you need to do 2k8 to 2k5 i would assume you would need to have db in s25 comp mode but should be ok. Just make sure that...
Adam Zacks-------------------------------------------Be Nice, Or Leave
April 26, 2010 at 3:35 am
We dont have any prod 2k8 servers but i have run tests using my own instances and it works fine 2005 to 2008.
Adam Zacks-------------------------------------------Be Nice, Or Leave
April 26, 2010 at 3:33 am
Agree with George.
I have two clusters like this and have found that the configuration manager tends to be mis-leading. Rely on Clust Admin and Services.msc (and of course ssms).
Adam Zacks-------------------------------------------Be Nice, Or Leave
April 19, 2010 at 4:14 am
To answer your question; if your waiting for tempdb to release space back to the os, you'll be waiting a long time. Cause it wont.
If you need to release space...
Adam Zacks-------------------------------------------Be Nice, Or Leave
April 19, 2010 at 4:03 am
YSL,
Completely agree with you and believe me, my position and the hoops I have to jump through are far from ideal; thats why i put in the bit about more...
Adam Zacks-------------------------------------------Be Nice, Or Leave
April 13, 2010 at 9:04 am
Raghavender (4/13/2010)
Here, if any user dont have any database roles but it has select permissions on some tables and execute permissions on some stored procedures...How to retrive that information ?
Run...
Adam Zacks-------------------------------------------Be Nice, Or Leave
April 13, 2010 at 8:56 am
Fair enough.
You shoould be aware though that having a logfile shrink, grow, shrik, grow like this will eventually see it fragmented all over your disk leading to long io's.
Adam Zacks-------------------------------------------Be Nice, Or Leave
April 13, 2010 at 8:52 am
Viewing 15 posts - 271 through 285 (of 619 total)