Viewing 15 posts - 4,111 through 4,125 (of 6,676 total)
AndrewSQLDBA (2/19/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
February 19, 2010 at 8:48 am
Is the destination database set to full recovery model? If so, are you running frequent transaction log backups?
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
February 19, 2010 at 8:40 am
That is not going to help your situation. Adding more log files won't have any affect because SQL Server writes to the log file sequentially.
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
February 19, 2010 at 8:33 am
AndrewSQLDBA (2/19/2010)
SQL BOL
System Administrator (sa) Login
System administrator (sa) is a special login...
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
February 19, 2010 at 8:26 am
AndrewSQLDBA (2/18/2010)
Create a simple SQL user...
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
February 18, 2010 at 7:40 pm
I have found that the only time the owner of a maintenance plan (or Agent job) has any issues is when that owner account is a domain user account. ...
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
February 18, 2010 at 12:47 pm
GT's
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
February 17, 2010 at 5:08 pm
Sorry - quoted wrong post. Meant to post the one above yours.
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
February 17, 2010 at 4:48 pm
GRE-452109 (2/17/2010)
Just to sound like an echo, backup the systems databases (Master, Model, MSDB) on a regular schedule.
Not true - in a disaster recovery scenario you will probably be restoring...
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
February 17, 2010 at 4:25 pm
Did you happen to copy/restore the system resource database at some point? If so, that would cause this kind of issue since that database has been upgraded - but...
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
February 17, 2010 at 4:19 pm
Lamprey13 (2/17/2010)
Jeffrey Williams-493691 (2/17/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
February 17, 2010 at 4:16 pm
twm (2/17/2010)
Any idea why it only changed the SQL Server version AFTER I started the instance in Single User Mode? Because when I initially installed S2K5/SP3 and rebooted, it...
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
February 17, 2010 at 4:10 pm
Lamprey13 (2/17/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
February 17, 2010 at 3:40 pm
Yes, the patch does update SQL Server and changes the version level.
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
February 17, 2010 at 3:13 pm
Ser Tharg (2/17/2010)
I work with a database that often shows up to 50% free space, shrinking releases space but thanks for the replies!
Okay - releases space to be used by...
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
February 17, 2010 at 1:55 pm
Viewing 15 posts - 4,111 through 4,125 (of 6,676 total)