Viewing 15 posts - 3,811 through 3,825 (of 6,676 total)
ErickTreeTops (5/19/2010)
When attempting a restore the same error occurs.
There must be...
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
May 19, 2010 at 6:14 pm
That is normal - it is not actually using the page file and just reporting the memory usage that SQL Server is taking as PF usage.
What are the min/max settings...
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
May 19, 2010 at 6:11 pm
While reviewing the transaction isolation levels, review the snapshot isolation section in further detail. If you decide to use that - be sure you understand the additional requirements 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
May 19, 2010 at 5:18 pm
Lamprey13 (5/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
May 19, 2010 at 5:06 pm
Instead of using TRUE/FALSE (two states), try using a datetime value for when the row was deleted. You can then use NULL to identify the active row - with...
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
May 19, 2010 at 1:43 pm
Read the article in my signature on managing transaction logs. If the transaction log is full, I would bet that you are not performing log backups regularly. 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
May 19, 2010 at 9:37 am
Or, it is a SAN snapshot technology that is performing a snapshot 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
May 19, 2010 at 9:35 am
These are generally messages related to using the VDI interface to perform backups or snapshots. Do you have a SAN backup utility performing backups on your system?
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
May 19, 2010 at 9:30 am
No, you shouldn't shrink the database files unless you are absolutely sure you will never need that space. Eventually, you will need that space again and the data files...
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
May 19, 2010 at 9:07 am
Krasavita (5/18/2010)
I only have CustomReports option, do you know why? Thank you
What version are your client tools - and what version are you connecting to? Those reports are not...
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
May 18, 2010 at 1:51 pm
I would recommend looking at synonyms. You define the synonyms for that system and create the views to use the synonyms. That way, when you move the code...
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
May 18, 2010 at 1:29 pm
There really isn't any easy way to copy/transfer maintenance plans from 2005 to 2008. It will take less time to just manually create them as needed.
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
May 18, 2010 at 1:20 pm
I am not sure I follow this - you want to start a process that takes 3 minutes to run, every 2 minutes? That means the previous execution will...
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
May 16, 2010 at 9:32 am
george sibbald (5/14/2010)
?http://msdn.microsoft.com/en-us/library/ms188694(SQL.90).aspx
Interesting, didn't know that - but then again I don't set that option or use it. Besides, did you see the comment that if you set 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
May 14, 2010 at 6:13 pm
george sibbald (5/14/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
May 14, 2010 at 5:25 pm
Viewing 15 posts - 3,811 through 3,825 (of 6,676 total)