Viewing 15 posts - 316 through 330 (of 707 total)
jshailendra (9/30/2011)
Until there are open/active transactions using the VLFs at the end of transaction log file, the shrink will not release the space.
Thanks for the quick response.
How to check that..?
September 30, 2011 at 2:07 am
Thank you all for the quick responses.
Had I taken atleast a full backup, I could have taken the tail log backup and do a PIT recovery, right ?
Thanks again.
September 23, 2011 at 7:56 am
Panders (9/23/2011)
when you mirror servers everything from the transaction log get "replayed" on the mirror server.
when you stopped the mirror all the transactions...
September 23, 2011 at 7:52 am
In principal database log.?
I am not able to fully understand the attached log...
Can anyone exlain pls....
Thanks for the quick response.
September 23, 2011 at 5:13 am
matt.newman (8/12/2011)
September 6, 2011 at 4:32 am
could you try creating a udl file (rename a text file to extn .udl) and then connecting thru it.
how about sqlcmd ?
Hi,
No even UDL is not working. Infact 'servername'...
August 31, 2011 at 1:57 am
Thanks all. Will try with all the solutions and see.
I have never installed express edition but I know that other versions of SQL Server 2008 have a window during the...
August 29, 2011 at 11:57 pm
Jayanth_Kurup (8/29/2011)
could you try creating a udl file (rename a text file to extn .udl) and then connecting thru it.how about sqlcmd ?
Thanks for the quick response.
Forgot to try...
August 29, 2011 at 1:30 am
Thank you clubbavich and matt.newman.
I will see if I can find it.
I will also search. Pls let me know incase if you find something.
Thanks again.
Smith
August 25, 2011 at 12:17 am
Thanks for your quick response.
2, you can have multiple instances
Means that microsoft book I baught is wrong..
I doubt if I need to contiue studyingthat book...
Wel, Any help on that...
August 23, 2011 at 1:53 am
Does the column that stores the application names contain duplicate entries ?
PC wise duplciates, yes there will be many.
Nothing but appplications installed on all the PCs.
August 22, 2011 at 4:41 am
Thanks Gail.
Only video .. Available in text format somewhere.?
Thanks again.
August 18, 2011 at 6:36 am
2) glenn allan berry has great diagnostic collection script
3) brent ozar has a good 'blitz' script
Thanks. Where can I find those scripts .?
August 16, 2011 at 11:49 pm
If you are looking for one such script i can pass one.
Yes, Please send it to me.
August 15, 2011 at 3:31 am
It'll try to shut down cleanly, depends what's running/outstanding.
Thanks Gila.
Can you explain a bit more pls.
When SQL will decide NOT to shut down cleanly.?
There's only so much time...
August 12, 2011 at 9:29 am
Viewing 15 posts - 316 through 330 (of 707 total)