Viewing 15 posts - 4,381 through 4,395 (of 6,676 total)
CirquedeSQLeil (11/16/2009)
As for the preferred RAID 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
November 16, 2009 at 11:58 am
If I had my choice of configurations, I guess it would all depend on the SAN we were using. On an EVA - I would want at least 80...
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
November 16, 2009 at 11:46 am
GSquared (11/16/2009)
If it has multiple peanuts, it's clustered. If it's just one peanut per database, then it's not. Seems simple to me.
What if you have a bunch 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
November 16, 2009 at 11:40 am
Bru Medishetty (11/13/2009)
Hmm Seems to be strange, have not got an idea what does it alter?Any way have you tried to rerun that job?
I think the alter is part 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
November 13, 2009 at 1:45 pm
Never mind about the version - I reviewed the original post and see that you are running SP3. Verify the account running both SQL Server and the Agent 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
November 13, 2009 at 1:44 pm
What is the version of SQL Server? I recall that there were some issues with SP1 and Integrity checks. Not sure if that applies here.
Is SQL Server running...
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
November 13, 2009 at 1:41 pm
View the history for the maintenance plan instead of the SQL Agent job. You will find additional information that might indicate exactly what is causing the failure.
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
November 13, 2009 at 1:04 pm
You don't have to perform a backup after switching between bulk-logged and full recovery models. Now, if you switch to simple - it will break the log chain 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
November 12, 2009 at 2:50 pm
Make sure you are using local temp tables instead of global temp tables. Local temp tables are preceded by a single # - global temp tables are preceded 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
November 12, 2009 at 11:52 am
You need to look up DATEADD in help (Books Online). You are going to setup a query where you will filter the results using the above function. Example:
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
November 10, 2009 at 4:41 pm
In BIDS - when designing the report, setup the parameters with default values. The default values you will use would be something like:
=DateAdd(DateInterval.Day, -1, Today())
Figure out what defaults 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
November 10, 2009 at 2:07 pm
You are going to have to look at setting up and using a linked server to access the database on another instance. What I would recommend you look at...
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
November 9, 2009 at 4:54 pm
Here is the process I use:
1) Create maintenance plan in SSMS as template. Create all sub-plans, tasks, etc...
2) Open BIDS and create new SSIS package
3) Add Existing Items to...
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
November 9, 2009 at 2:21 pm
SQLNewbie-610691 (11/9/2009)
How do you setup to delete .BAK file...
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
November 9, 2009 at 11:58 am
When you looked at the maintenance plan history - which task failed? What was the error message for the task that failed?
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
November 7, 2009 at 8:40 am
Viewing 15 posts - 4,381 through 4,395 (of 6,676 total)