Viewing 15 posts - 4,336 through 4,350 (of 6,676 total)
You can start by running the standard Disk Usage by Tables report. This report will not give you columns for the table - but gives you everything else 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
December 29, 2009 at 3:51 pm
Jonathan Turlington (12/29/2009)
An alternative to what I...
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 29, 2009 at 3:41 pm
You reset it to 100MB from what? If the last time it autogrew was back on the 15th - then the only other option is that someone manually grew...
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 29, 2009 at 3:37 pm
BSavoie (12/29/2009)
CREATE INDEX MyIndex ON...
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 29, 2009 at 3:35 pm
GilaMonster (12/29/2009)
Check with whoever's responsible for the backups and ask whether or not there are any differential backups been run. If there are, to avoid messing up the recovery...
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 29, 2009 at 2:41 pm
In the following article: http://msdn.microsoft.com/en-us/library/ms188783(SQL.90).aspx under the heading 'Required SET Options for Indexed Views' it clearly shows what values need to be defined when creating an indexed view.
There is also...
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 29, 2009 at 2:31 pm
What is the autogrowth setting for that database now? Review the standard report for Disk Usage which will include a record of all autogrowth events since the last time...
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 29, 2009 at 2:16 pm
There is no native utility for restoring a single table. If you were using a third-party backup utility, that utility might have that capability.
The only way to do this...
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 28, 2009 at 8:09 pm
Check the SQL Server logs to find out if the instance has been restarted. It might be a situation where the system crashed and it is taking a long...
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 28, 2009 at 8:07 pm
Steve Jones - Editor (12/28/2009)
Typically you would do this:
select *from sales
where datesvc >= '9/1/2009'
and datesvc < '10/1/2009'
To expand on what Steve is showing here, 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
December 28, 2009 at 8:05 pm
As far as I know - SQL Server does not support databases on encrypted volumes using Truecrypt. I would bet that is the cause for your problems.
I still don't...
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 28, 2009 at 7:02 am
Is this a named instance on your local PC? If so, what is the name of the instance and how are you trying to connect?
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 25, 2009 at 9:25 am
Using that does not do what you are expecting it to do - it is a holdover from when the devices were tape.
Stop using a device - use a 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 25, 2009 at 9:23 am
I would recommend changing the recovery model to simple since it is only a dev server. I would also recommend that you start backing up the database daily -...
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, 2009 at 12:50 pm
Yes, as long as you have the transaction log entries available you can use a tool like that to recover. Glad you were able to get it back where...
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, 2009 at 11:53 am
Viewing 15 posts - 4,336 through 4,350 (of 6,676 total)