Viewing 15 posts - 4,756 through 4,770 (of 6,676 total)
sarvesh singh (8/4/2009)There are two maintenance cleanup task. One with extension BAK and the other with TRN for deleting files older than 2days. But this is not working.
You don't by...
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
August 4, 2009 at 8:49 am
There is nothing in SQL Server that will tell you anything about the cluster specifically. Why do you need to be able to get this information from SQL Server...
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
August 4, 2009 at 8:40 am
I don't see the information from sys.indexes - but that is okay. What I do see is that you have a HEAP (object id 1215343394) that could be taking...
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
August 3, 2009 at 5:48 pm
Can you run the following queries for me - and post the results?
Use {your database here};
SELECT * FROM sys.indexes;
SELECT * FROM sys.dm_db_index_physical_stats(db_id(), Null, Null, Null, 'DETAILED');
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
August 3, 2009 at 4:20 pm
bpowers (8/3/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
August 3, 2009 at 1:04 pm
Lowell (8/3/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
August 3, 2009 at 1:02 pm
Check the SPN records that were created - you probably need to remove the old ones and create new ones that point to the correct server instance.
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
August 3, 2009 at 11:49 am
ifila (8/3/2009)
I dont want a direct connection to my server from another...
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
August 3, 2009 at 11:46 am
Where are you changing the password? Try using SQL Server Configuration Manager to change the password instead of the services applet.
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
August 3, 2009 at 10:42 am
Please review the article I link to in my signature to learn how to post your question and get better, faster answers.
To answer your question:
SELECT Id
...
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
August 3, 2009 at 10:36 am
ifila (8/3/2009)
I have reduced the size of the DB to 50 records, and compressed it, but it is still 4 GB !
I...
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
August 3, 2009 at 10:29 am
You still need to lock pages in memory for x64 systems. Grant that right to the service account and you will no longer get that message.
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
August 3, 2009 at 10:11 am
What is the extension you put in the maintenance cleanup task? Do you have two tasks created, one for your full backups and another for your transaction log backups?
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
August 3, 2009 at 9:53 am
Two tricks are available, but limited since you are still on 2000. If you upgrade to 2005 - these 'tricks' are very easy to implement.
First trick is to create...
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
August 3, 2009 at 9:52 am
Jeff Moden (7/31/2009)
Heh... and I guess they're also known as "OTLT's". Thanks, Jeffrey. 🙂
It really doesn't matter what name you use - they have a lot of problems. ...
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 31, 2009 at 8:56 pm
Viewing 15 posts - 4,756 through 4,770 (of 6,676 total)