Viewing 15 posts - 4,216 through 4,230 (of 6,676 total)
lisbon (1/28/2010)
Hi,As noted before, if you always do full backups you can change the recovery model to SIMPLE in database options and the log will shrink after each backup.
Best,
lx
Neither 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
January 28, 2010 at 7:56 am
Compatibility mode affects what commands are available in that database. It is used generally for backward compatibility to allow legacy code written using deprecated code to run on 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
January 27, 2010 at 6:29 pm
How about this:
SELECT *
FROM #s
WHERE name collate Latin1_General_BIN = upper([name])
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
January 27, 2010 at 6:26 pm
Sorry - don't have another URL and not sure why your virus scanner is seeing something that isn't there.
Here is an example from that site, which shows how to create...
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
January 27, 2010 at 6:16 pm
Take a look at this article: http://support.microsoft.com/kb/934396
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
January 27, 2010 at 5:42 pm
It sounds like you are building up a SQL string in your code using concatenation, and then submitting that to SQL Server to be executed.
Please be aware that technique 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
January 27, 2010 at 5:36 pm
shaunspad (1/27/2010)
However I'm not detaching the DB's when I move them, I'm simply taking them offline. I'm...
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
January 27, 2010 at 5:25 pm
For future reference, it is much easier to install the system databases into their final location instead of using the default values and then moving them.
During the install, select 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
January 27, 2010 at 8:51 am
CirquedeSQLeil (1/26/2010)
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
January 27, 2010 at 8:43 am
A couple of previous suggestions recommend changing the recovery model to SIMPLE and back to FULL. That should only be used as a last resort because it will break...
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
January 27, 2010 at 8:39 am
Here is the article I was referring to: http://www.sqlskills.com/BLOGS/KIMBERLY/post/Transaction-Log-VLFs-too-many-or-too-few.aspx
The sizing at 8GB probably is not relevant for you - but, the information on how the VLF's are created will probably...
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
January 27, 2010 at 8:18 am
CirquedeSQLeil (1/26/2010)
Paul White (1/26/2010)
The Dixie Flatline (1/26/2010)
You're an evil man, Emperor Paulpatine.... :laugh:
Oh so The Dixie Flatline *is* Bob! I missed the transition somewhere...d'oh!
Thanks for the high...
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
January 26, 2010 at 9:40 pm
There really isn't anything that will show the growth over time - but, you can look at the backup history of the transaction log and see what times are 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
January 26, 2010 at 9:21 pm
phil.curtis (1/26/2010)
My goal is to use the mail interface to email notifications on DTS job failures.
I'm sorry - but what mail interface? You cannot use SQL Mail without installing...
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
January 26, 2010 at 7:18 pm
There really isn't a formula for figuring this out, as there can be a lot of factors for how large a transaction log will need to be.
Simply put, the transaction...
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
January 26, 2010 at 7:16 pm
Viewing 15 posts - 4,216 through 4,230 (of 6,676 total)