Viewing 15 posts - 4,426 through 4,440 (of 6,676 total)
revanthanne (10/26/2009)
Hi Williams,you made my day,Exactly I should not have the period infront of bak file.
I am specifying as .bak
Great - glad you were able to get this to work....
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
October 26, 2009 at 4:33 pm
I hear you - it is the same here also. I wasn't really trying to ruffle any feathers - I hope it didn't come across that way. 🙂
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
October 26, 2009 at 2:31 pm
You can take SQL Server offline from cluster administrator. Once it is offline, on the same node that was hosting SQL Server - you can then start 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
October 26, 2009 at 2:23 pm
From the maintenance cleanup task - click on the button to see the generated code and paste that here.
First, when using the task - you can either cleanup backup files,...
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
October 26, 2009 at 2:15 pm
ALZDBA (10/26/2009)
Indianrock (10/26/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
October 26, 2009 at 1:46 pm
I don't think that trying to determine how large the transaction log is going to get is going to work for you. It all comes down to the pattern...
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
October 25, 2009 at 8:55 pm
G33kKahuna (10/25/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
October 25, 2009 at 10:52 am
Jeff Moden (10/23/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
October 23, 2009 at 10:30 pm
Not sure about quicker - but you could always setup a linked server. How you connect to Informix is dependent upon what is available for that system.
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
October 23, 2009 at 3:44 pm
Oh - I agree and my preference is to do stuff like this after hours regardless. If you have a very good SAN team who has lots of experience...
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
October 23, 2009 at 1:49 pm
CirquedeSQLeil (10/23/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
October 23, 2009 at 1:27 pm
halifaxdal (10/23/2009)
I also just changed the owner to sa, it returns same 0 to all number - that's not right.
The owner of the job is not the user that 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
October 23, 2009 at 1:20 pm
fred2002 (10/23/2009)
noi explained it wrong.
first we restricted the size to 300MB
But now due to the errors we allw it to 1.2GB.
MS advise to fix a max size for transaction log
Do...
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
October 23, 2009 at 1:11 pm
There is no upgrade path from 32bit to 64bit. What you would have to do is install a new x64 instance and migrate the databases.
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
October 23, 2009 at 12:19 pm
frovello (10/23/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
October 23, 2009 at 9:28 am
Viewing 15 posts - 4,426 through 4,440 (of 6,676 total)