Viewing 15 posts - 1 through 15 (of 16 total)
GilaMonster (8/18/2015)
Chris.Hubbard4U (8/17/2015)
GilaMonster (8/14/2015)
August 18, 2015 at 5:50 pm
Lynn Pettis (8/17/2015)
Read this:
I regret that I did not answer your questions.
It is a default instance and the command returns NULL.
Thanks for the link.:-)
August 18, 2015 at 5:39 pm
Lynn Pettis (8/17/2015)
Two questions:1) is this a default instance
2) What does the following return: select SERVERPROPERTY('machinename');
I did not answer you first question; sorry about that.
I can not think of anyone...
August 17, 2015 at 2:07 pm
Lynn Pettis (8/17/2015)
What does this return:select * from sys.servers;
It does not return any rows:unsure:
August 17, 2015 at 1:08 pm
GilaMonster (8/14/2015)
August 17, 2015 at 12:44 pm
TheSQLGuru (8/14/2015)
2) I think it won't clear until reaches end of current VLF.
3)
SELECT log_reuse_wait_desc
FROM sys.databases
WHERE name = 'MyDB';
4)...
August 17, 2015 at 12:42 pm
DBA From The Cold (8/14/2015)
I'd guess that you have a query still executing which is preventing the log from being cleared
Yes but I'm committing the transactions. Thanks.:-)
August 17, 2015 at 12:41 pm
Eirikur Eiriksson (8/14/2015)
Chris.Hubbard4U (8/14/2015)
Eirikur Eiriksson (8/14/2015)
Chris.Hubbard4U (8/14/2015)
Where I execute the command SELECT @@ServerName it returns NULL?This just started today.
What could cause that?
What does
SELECT SERVERPROPERTY ( 'InstanceName' )return?😎
NULL:unsure:
Are you...
August 17, 2015 at 12:37 pm
GilaMonster (8/17/2015)
Duplicate post. No replies pleaseReplies to http://www.sqlservercentral.com/Forums/Topic1712220-3077-1.aspx
Sorry it was an accident.:blush:
August 17, 2015 at 7:53 am
Eirikur Eiriksson (8/14/2015)
Chris.Hubbard4U (8/14/2015)
Where I execute the command SELECT @@ServerName it returns NULL?This just started today.
What could cause that?
What does
SELECT SERVERPROPERTY ( 'InstanceName' )return?😎
NULL:unsure:
August 14, 2015 at 2:56 pm
Eirikur Eiriksson (8/14/2015)
Chris.Hubbard4U (8/14/2015)
I have a database In Recovery.Where do I check the completion status of the recovery?
Quick thought, query sys.dm_exec_requests and check for command='RECOVERY'
😎
I queried that table but it...
August 14, 2015 at 11:24 am
What is really weird is that I can Select from a Table but it is in recovery mode.
That does not make sense?
August 14, 2015 at 11:22 am
I can't even Drop the 2 Test Databases that are stuck at recovery.
How can I get rid of them?
August 14, 2015 at 11:17 am
Viewing 15 posts - 1 through 15 (of 16 total)