Viewing 15 posts - 2,926 through 2,940 (of 6,676 total)
You can reduce your backup time by using one of the third-party tools that compresses backups.
Redgate's SQL Backup
Quest's Litespeed
Idera's SQL Safe
All of the above are good options, and each one...
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
December 2, 2011 at 7:29 pm
junk.jjk (12/2/2011)
The other...
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
December 2, 2011 at 12:06 pm
Select dateadd(month, datediff(month, -1, cast(@year as char(4)) + '-' + cast(@month as varchar(2)) + '-01'), -1)
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
December 2, 2011 at 12:03 pm
Can you change the owner of the database to 'sa' - and then add this user with db_owner rights?
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
November 29, 2011 at 11:32 am
Glad to have helped.
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
November 28, 2011 at 4:12 pm
sqlfriends (11/28/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
November 28, 2011 at 4:10 pm
Steve Jones - SSC Editor (11/28/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
November 28, 2011 at 4:00 pm
sqlfriends (11/28/2011)
So how can I reduce the log backup...
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
November 28, 2011 at 11:52 am
quillis131 (11/28/2011)
kramaswamy (11/28/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
November 28, 2011 at 11:44 am
There will always be at least one VLF that is inuse - it is probably the one you are looking 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
November 28, 2011 at 11:33 am
For question 2 - if you already have the plan open in the editor to modify, then trying to modify again won't do anything.
For question 1, there is a small...
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
November 27, 2011 at 6:26 pm
Jeff Moden (11/27/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
November 27, 2011 at 6:21 pm
Also, verify whether or not there are primary keys defined on the tables. That could also be causing the tables to be read only from ODBC.
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
November 26, 2011 at 9:48 am
Here is an article that might explain what you are seeing: http://msdn.microsoft.com/en-us/library/aa337286.aspx
It could simply be the fact that the login through your application does not have VIEW DEFINITION on 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
November 26, 2011 at 9:45 am
Sounds like an issue accessing the domain controller and verifying that domain user. When you created the login, did you create it exactly the same as what is in...
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
November 25, 2011 at 12:11 pm
Viewing 15 posts - 2,926 through 2,940 (of 6,676 total)