Viewing 15 posts - 4,846 through 4,860 (of 6,676 total)
Without a backup - your only other option is going to be a log reader tool. That will only work if your database is in full recovery model and...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 10, 2009 at 3:21 pm
derreckdean (7/10/2009)It's a brand-new SQL Server 2008 install on a freshly-wiped box. I'm logged in as Administrator using NTLM auth.
I tried to reattach the DB as SA, no dice....
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 10, 2009 at 2:43 pm
You can query WMI to get the processor counts, however - you might need to apply a patch first:
http://support.microsoft.com/kb/932370/
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 10, 2009 at 2:39 pm
Could it possibly be a permissions issue? Are you logging into SQL Server with a privileged account or a user account?
Try running sp_change_users_login with the report option and see...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 10, 2009 at 2:21 pm
sanderstad (7/10/2009)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 10, 2009 at 2:15 pm
I could see a different execution plan being generated - but not different results. Both queries should return the same results and the fact that they are different says...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 10, 2009 at 2:08 pm
I have to agree with Jack - you are pretty much screwed. My guess is that you copied the mdf/ldf files for that database from a particular directory, and...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 10, 2009 at 2:02 pm
I didn't even think about that issue, although I have run into it a couple of times. Normally, it shows up in the history for the maintenance plan on...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 9, 2009 at 3:45 pm
Here is a different method (thanks Lynn for the setup):
If object_id('tempdb..#temp', 'U') Is Not Null
Drop Table #temp;
Create Table #temp (time char(4));
Insert Into #temp
Select '0900'
...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 9, 2009 at 2:24 pm
Right-click on SQL Server Agent, go to properties and select the Alert page and verify that this is configured for Database Mail.
Not sure this will fix your problem.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 9, 2009 at 1:48 pm
Did you validate that the SQL Server Agent Alert system has been setup?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 8, 2009 at 10:30 am
Glad I could help
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 8, 2009 at 10:14 am
When using detailed, you should only be worried about the bottom (data) level. I think you are fine for now.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 8, 2009 at 9:30 am
So, that is showing us index level 4 - what are the values for the other index levels? And, where are you seeing that this table has millions of...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 7, 2009 at 9:03 pm
Can you provide a sample of what you are seeing when you use DETAILED? I am going to guess that you are seeing fragmentation at one of the leaf...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 7, 2009 at 8:33 pm
Viewing 15 posts - 4,846 through 4,860 (of 6,676 total)