Viewing 15 posts - 3,016 through 3,030 (of 6,676 total)
If it isn't clear - the reason by your transaction logs are growing is because you are not performing regular transaction log backups.
Sounds like you got in the 'habit' 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
August 8, 2011 at 2:45 pm
Now that this is fixed, you really need to remove that log truncation/shrink process. It is not necessary and is causing more problems than it would ever resolve.
And, please...
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 7, 2011 at 6:57 pm
Gift Peddie (8/7/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
August 7, 2011 at 6:48 pm
I was hoping that would lead you to look at how the variable @studentID is defined. Also, I believe you meant to say it is uniqueidentifier.
So, you have 2...
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 7, 2011 at 4:33 pm
Jeff Moden (8/7/2011)
sqlfriends (8/5/2011)
Our production server will be enterprise version
For the license issue, can I just use developer...
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 7, 2011 at 3:03 pm
What is the data type of the identity column on the table you are inserting into?
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 7, 2011 at 2:40 pm
I have absolutely no idea what you are talking about - nor do I think you do.
Care to explain in further detail how your environment differs from most normal installations...
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 7, 2011 at 2:32 pm
Gift Peddie (8/7/2011)
The only time you need to have the agent service account as part of the local administrators group is IF YOU REQUIRE the autostart functionality to be enabled....
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 7, 2011 at 11:45 am
Gift Peddie (8/7/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
August 7, 2011 at 11:17 am
I am biased towards SSIS also...found I can get much better performance and manage space using SSIS much easier than using linked servers.
That is the other thing I forgot 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
August 6, 2011 at 7:51 pm
I will second the SSIS option - it will perform better than using linked servers to update and won't require pulling the data across the linked server to a temp...
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 6, 2011 at 1:23 pm
You have to manually update the table - the table you want is the sysdtspackages90 table in the msdb database. Set the ownersid column to 0x1 (sa) for package...
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 6, 2011 at 1:20 pm
shaka.hi (8/5/2011)
Thank you..I just thought it was bit conicidental that the file is resized to almost exactly the same size as the original.
Check the autogrowth setting - the space 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
August 6, 2011 at 1:11 pm
To grant access to SQL Agent - you are not going to be able to use an AD group. You need to add each individuals login and it is...
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, 2011 at 11:25 pm
If everything worked fine in test - what are the differences between test and prod? Creating a linked server is not very difficult, but installing the Oracle software 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
August 3, 2011 at 7:59 pm
Viewing 15 posts - 3,016 through 3,030 (of 6,676 total)