Viewing 15 posts - 3,061 through 3,075 (of 6,676 total)
I would also recommend that you setup a server side trace to capture all database calls that take more than xx seconds. You can start with 5 seconds 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 18, 2011 at 2:33 pm
The first DBA is wrong - you cannot even enable AWE on a 32-bit machine without setting the lock pages in memory right for a service account. Unless 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
July 18, 2011 at 2:26 pm
And - there are no shortcuts. You will have to wait for it to complete the rollback.
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 18, 2011 at 2:18 pm
upstart (7/15/2011)
So that's why my code basically Pings...
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 16, 2011 at 9:54 am
Check the log_reuse_wait_desc column in sys.databases for that database. If it shows up as REPLICATION, then you have an issue with replication not completing so those transactions cannot be...
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 16, 2011 at 9:44 am
Shah_hs (7/14/2011)
Do you mean i need to run setup to install fresh instance on Server A? Since Server A...
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 14, 2011 at 2:37 pm
I am a bit confused by this query - what is being counted here? I would bet anything that there is no reason to even join to all 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 13, 2011 at 4:23 pm
No - you do not need to take down the production system. But, you might need to stop the transaction log backups if you run them often enough that...
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 13, 2011 at 4:17 pm
GilaMonster (7/13/2011)
jpSQLDude (7/13/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
July 13, 2011 at 4:07 pm
Shah_hs (7/12/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
July 12, 2011 at 8:24 pm
ruffindmc (7/12/2011)
Both locations have SQL Server 2008 database. My location uses the BI tools SSRS, SSIS, SSAS.
Microsoft .NET framework.
What I need to do is create reports...
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 12, 2011 at 8:18 pm
opc.three (7/12/2011)
Jeffrey Williams-493691 (7/12/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
July 12, 2011 at 8:10 pm
I am not sure I understand the configuration you have - or what it is you want to accomplish.
There are several ways you can get data from another system, each...
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 12, 2011 at 2:25 pm
I would recommend SSIS also - and I don't see Service Broker as the right solution. I would think service broker is more geared toward event driven processing -...
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 12, 2011 at 2:20 pm
You should be able to run the process to add a node for that instance. You run that on the additional node where you want that instance. Remember...
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 12, 2011 at 2:17 pm
Viewing 15 posts - 3,061 through 3,075 (of 6,676 total)