Viewing 15 posts - 3,121 through 3,135 (of 6,676 total)
If you have a transaction surrounding 5 stored procedure calls, and each call should result in a single row in each table that you can track to - then you...
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
June 22, 2011 at 6:37 pm
No - never...absolutely not.
First, although rare there have been a few occasions where applying a service pack broke existing code in the application. Service Packs should always be thoroughly...
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
June 22, 2011 at 5:49 pm
There has to be either a rollback occurring or another process performing a delete.
If this is something that happens on a regular basis, you need to build a trace to...
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
June 22, 2011 at 5:36 pm
If you have been granted the appropriate rights on the report server, you can change from the default view to the detail view (on the right side - header).
Once you...
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
June 21, 2011 at 8:18 pm
I would also be curious about how the TVF is created. Is it an inline TVF or a multi-statement TVF?
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
June 20, 2011 at 2:35 pm
homebrew01 (6/20/2011)
Brandie Tarvin (6/20/2011)
Also, check and see how often your job log clears itself out. That would be the reason why you're not seeing a history on the job.
Yes, 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
June 20, 2011 at 2:19 pm
Drop the login and recreate it with the same SID - that way, when the database is restored the SIDs match.
You can do this using sp_help_revlogin and passing the username...
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
June 19, 2011 at 8:14 pm
sqlfriends (6/17/2011)
But just want to clarify this, so simple recovery mode's database, they will still use transaction log, but we still need to divide...
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
June 17, 2011 at 2:37 pm
When I hear someone say that they have been told not to use temp tables, it usually means they are abusing temp tables and building convoluted processes to get their...
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
June 17, 2011 at 10:30 am
AlexGreen (6/17/2011)
There are also third party tools available to...
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
June 17, 2011 at 9:55 am
Dan.Humphries (6/16/2011)
The Full DB Backup runs about an hour when it is at a TB but less then 10 minutes when it is reduced to the 100GB size.
I don't 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
June 16, 2011 at 3:02 pm
sysadm 77674 (6/16/2011)
OLDCHAPPY (6/16/2011)
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
June 16, 2011 at 2:24 pm
Lee Crain (6/15/2011)
The lengths of the values in the REPLICATE...
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
June 15, 2011 at 6:38 pm
I think you need to figure out why you built up 56GB of transactions. Also, you need to work with your network team to figure out what is going...
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
June 15, 2011 at 6:30 pm
Daryl-273852 (6/15/2011)
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
June 15, 2011 at 3:14 pm
Viewing 15 posts - 3,121 through 3,135 (of 6,676 total)