Viewing 15 posts - 4,261 through 4,275 (of 6,676 total)
How are you taking snapshots? Are you using a tool that understands SQL Server and is capable of freezing the databases before you take your snapshot?
If not, then 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
January 13, 2010 at 1:50 pm
First - pinning a table in memory is no longer supported and shouldn't be considered. SQL Server 2005/2008 manages this much better.
Second, define first time you are running your...
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
January 13, 2010 at 1:45 pm
I don't follow - what output are you expecting and what output is missing?
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
January 13, 2010 at 1:33 pm
I would try rebuilding that index before doing anything else. All of those errors are related to the same index (it looks like) and it appears that the index...
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
January 12, 2010 at 7:00 pm
Just one note - for MonthsInService using that calculation are you aware that this will give you a value of 1 month even though there is only one day difference?
DATEDIFF(month,...
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
January 12, 2010 at 12:54 pm
I would look at using 3 databases - not servers.
DatabaseA has application code and access to the data.
DatabaseB and C alternate between build cycles. When B is active, C...
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
January 12, 2010 at 12:16 pm
Look for a scheduled job that performs a reindex operation on that database. I would bet that the log file is growing to that size during this maintenance.
Also, look...
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
January 12, 2010 at 9:52 am
If you want the data from the day one year ago, calculate that day first:
DECLARE @startDate datetime;
SET @startDate = dateadd(year, -1, dateadd(day, datediff(day, 0, getdate()), 0));
Now, you can perform 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
January 12, 2010 at 9:28 am
http://www.sqlservercentral.com/articles/Administration/2960/
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
January 12, 2010 at 8:20 am
Here is the code I use:
Declare @dbname sysname
,@execSql varchar(max);
Declare dbname Cursor Local Static For
Select...
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
January 11, 2010 at 4:18 pm
Brad M. McGehee (1/11/2010)
tibor_karaszi (1/11/2010)
Mani,Consider using Ola Hallengren's scripts: http://ola.hallengren.com/
I often incorporate some of Ola's scripts inside my Maintenance Plans, running them as "Execute SQL Server Agent Job" tasks.
I do...
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
January 11, 2010 at 2:33 pm
That procedure needs to be run in the context of the database where you want the stats updated. Basically, you are running your procedure over and over in 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
January 11, 2010 at 2:31 pm
nikhil.verma (1/11/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
January 11, 2010 at 1:14 pm
Not that this is going to help you - but I don't know of anyone who backs up directly to tape from SQL Server. The generally accepted method is...
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
January 11, 2010 at 1:04 pm
What is the purpose of removing that access from the public role? What is it you are trying to accomplish here?
Take a look at VIEW DEFINITION in books online....
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
January 11, 2010 at 12:57 pm
Viewing 15 posts - 4,261 through 4,275 (of 6,676 total)