Viewing 13 posts - 1 through 13 (of 13 total)
Actually I do not have those mdf and ldf files to put back
September 24, 2009 at 12:06 am
Thanks Roy for your comments. But will the data get in sync with the approach you mentioned? I tried but the problem, data is not getting in sync.
Ziljan
April 6, 2009 at 10:37 am
Thank you so much for your response. Backup and Restore seems like a good idea but I have to add new articles to the publication, and hence generate a new...
March 26, 2009 at 12:18 am
Thanks Mauro and Brandie for your comments. The server is 64 bit and the OS is recognizing the memory. It showing what the system has.
Thanks again.
March 9, 2009 at 10:31 am
ALTER INDEX
REBUILD WITH (ONLINE = ON)
actually helped to defragment most of indexes in my databases, but when I tried this query in one of my database,...
July 30, 2008 at 11:30 pm
Thank you so much for your reply.
I tried to use the script but it gave me the following error.
Msg 14607, Level 16, State 1, Procedure sysmail_verify_profile_sp, Line 42
profile name is...
June 10, 2008 at 12:36 am
Probably you might have too many SQL connections, and it has been able to load all the connections, so it is timing out.
try SP_who2 gives you same information.
April 23, 2008 at 11:54 pm
Micorsoft SQL Server 2005 SP3 will be available pretty soon.
April 6, 2008 at 1:05 am
Chirag, could you provide me little more detail on figuring out blocking by using activity monitor?
Thanks
February 13, 2008 at 11:03 pm
Can activity Monitor be handy in detecting the blocking? If so how?
Thanks
February 13, 2008 at 3:03 pm
Thank You again for clearing some misunderstandings.
So, can I conclude that the only way to resolve the growing log is to take T log back up which truncates the...
January 6, 2008 at 3:50 pm
Thank you so much for your time and effort. Like most of you said taking transaction log back up truncates the inactive portion of log and shrinks the t log...
January 3, 2008 at 11:26 pm
Viewing 13 posts - 1 through 13 (of 13 total)