Viewing 15 posts - 3,466 through 3,480 (of 6,676 total)
That error indicates that there was an issue with the network. When backing up across the network, if there are any issues with the connection it will cause 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
December 24, 2010 at 10:13 am
loki1049 (12/22/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
December 24, 2010 at 9:59 am
Grant Fritchey (12/20/2010)
You could, with only a little bit more work, take advantage of...
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 20, 2010 at 2:41 pm
sqlbuddy123 (12/20/2010)
SQL Server needs to be restarted for the changes to take affect.
Only if you are moving the files is a restart necessary. If you are only adding...
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 20, 2010 at 2:32 pm
Gail has a couple of posts starting here: http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/
This should help you understand what you are seeing.
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 17, 2010 at 11:51 am
Are you - perhaps - using a third-party backup utility?
Another thing to validate...is the include sub-folders box checked? If so, are the backups in a sub-folder under that folder?
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 16, 2010 at 2:43 pm
Jason Norsworthy (12/15/2010)
I'll be dealing with possibly having to roll back locally installed databases, with numerous variations in schema. (I didn't create them!) I've never had...
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 16, 2010 at 2:38 pm
View the history on the maintenance plan - not the history on the job.
BTW, you do not appear to be backing up the transaction logs frequently enough. If all...
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 16, 2010 at 2:35 pm
If the database was not backed up while in single user mode, then it will not be restored in that condition. So, no - you won't need to set...
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 16, 2010 at 2:31 pm
I would recommend investing in one of the backup compression tools that are available.
Quest Litespeed - I use this one
Redgate SQL Backup - also a very good tool, and less...
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 14, 2010 at 8:04 pm
Is there any possibility of getting copies of a backup prior to the corruption? Normally, you would be sending your backups offsite somewhere for DR.
If so, you could restore...
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 14, 2010 at 7:55 pm
david.jobin 9674 (12/14/2010)
To make it work, you have to elevate the process with administrative privilege (UAC)
So you open...
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 14, 2010 at 7:40 pm
Steve Jones - SSC Editor (12/11/2010)
However when I need finer control,...
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 11, 2010 at 7:50 pm
Anna_SQL (12/10/2010)
Thanks,So back to my question any step-by-step articles or white page about restore system dbs?
Is this a common task for DBAs?
Thanks
I would say this is not a common task...
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 10, 2010 at 2:17 pm
snivas (12/10/2010)
OS "Windows 2003 64 bit SP2
MEMEORYCLERK_SQLBUFFERPOLL
Virtual memory Reserved is :33 GB
Virtual memory commited...
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 10, 2010 at 2:13 pm
Viewing 15 posts - 3,466 through 3,480 (of 6,676 total)