Viewing 15 posts - 4,516 through 4,530 (of 6,676 total)
I don't have time right at this moment to write it all up - but take a look at the previous query we worked on. The rules appear 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
October 5, 2009 at 7:59 am
That's why I keep stating data files - I've had a few systems where they didn't have mdf/ndf files because someone decided to change it. SQL Server doesn't really...
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 4, 2009 at 6:00 pm
Using CONVERT to a VARCHAR(20) will not remove the time portion. And, yes - the method I show is one of the fastest methods for zeroing out the time...
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 4, 2009 at 4:54 pm
If your date is not null, but is actually an empty string - the empty string is evaluated as a 0 which is 19000101. Not sure that is the...
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 4, 2009 at 3:35 pm
Okay, then you have specified multiple files for the restore where you only need to specify one of the backup files.
I am not sure what your intent is with 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
October 4, 2009 at 1:35 pm
It sounds like you did not use or create a mirror backup, but instead striped your backup across multiple files.
If you just put in two files in the backup window...
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 4, 2009 at 9:52 am
The thing I like about the maintenance plans is the fact that I get all of the history for the sub-plans without having to implement anything myself.
A lot of my...
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 4, 2009 at 9:47 am
repent_kog_is_near (10/4/2009)
If the data and index files are separated (mdf and ndf), does it matter where the amount of free space is required/needed?
Yes, your log files should be stable 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
October 4, 2009 at 9:02 am
repent_kog_is_near (10/3/2009)
Do you always beat the Autogrowth before it kicks in (If you suspect from your monitoring that it is going to happen in the next 2 weeks, do 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
October 4, 2009 at 9:01 am
The amount of free space is from experience only. Nothing specific from Microsoft - but 10 years of practical experience has shown that being able to give management 6...
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 3, 2009 at 9:20 pm
You are welcome - glad I could help.
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 3, 2009 at 7:29 pm
Yes, if you backup/restore all databases - the files associated with those databases will be defragmented.
No technical reason for sizing in MB's - just preference. For me, it just...
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 3, 2009 at 7:28 pm
What other files reside on that volume? If there are other files - are they other database files or are they something else? If something else, you should...
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 3, 2009 at 3:39 pm
Dan, yes you understand correctly. If you have the space available and expect to continue growing, there is no reason not to extend the database to 300GB.
Yes, with the...
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 3, 2009 at 1:22 pm
First, for a 200GB file I would not use a percentage for auto growth - I would set it to a fixed size. I would probably set it at...
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 2, 2009 at 8:14 pm
Viewing 15 posts - 4,516 through 4,530 (of 6,676 total)