Viewing 15 posts - 6,016 through 6,030 (of 6,676 total)
DEL D:\backup\data\SPProd_Cfg _10-19-2008.bak
The above has a space following Cfg. Don't know what else I can say other than the command you have posted has that space in it which...
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
October 21, 2008 at 1:49 pm
Davroche (10/21/2008)
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
October 21, 2008 at 1:46 pm
Okay, I think I know where the problem is - however, you are going to have to determine how to fix it. The easiest way to find the problem...
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
October 20, 2008 at 4:05 pm
You have a space after Cfg and before the underscore which is causing the command to fail. Remove the extra space and it should work.
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
October 20, 2008 at 3:46 pm
Yeah, doesn't sound like simple is going to work. And yes, you need to truncate the transaction log before it will shrink. When you perform a transaction log...
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
October 20, 2008 at 3:37 pm
Okay, the transaction log on the source system needs to be managed. To start, what is the recovery model for that database? And, how often are you backing...
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
October 20, 2008 at 3:09 pm
How large is the transaction log on the system where you took the backup? Not only do you need space for the database (*.mdf), but you need space for...
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
October 20, 2008 at 2:49 pm
For Litespeed, you can either use 'xp_procedure' or 'xp_slssqlmaint'. I use 'xp_slssqlmaint' and set it up as:
Execute master.dbo.xp_slssqlmaint '-MAINTDEL -DELFOLDER "%backupDirectory%%database% -DELEXTENSION "%extension%" -DELUNIT "%minutes%" -DELUNITTYPE "minutes" -DELUSEAGE';
Replace 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
October 20, 2008 at 1:59 pm
You can create a non-clustered index on the column(s) you want indexed. You don't need to drop the clustered 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
October 20, 2008 at 1:08 pm
This is a simple group by query:
Select cpp.Service
,Sum(cpp.PhaseValue -(cpp.PhaseIPT + cpp.Supplier1Charge + cpp.Supplier2Charge)) As Total
From yourTable cpp
Where CPP.PhaseStartDate >=...
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
October 20, 2008 at 12:23 pm
nilmov (10/19/2008)
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
October 19, 2008 at 4:37 pm
Perry Whittle (10/18/2008)
use the following to start, stop and close the trace(must stop a trace before it can be closed. Must be closed before you can access the file)
Just 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
October 19, 2008 at 9:42 am
Leo (10/19/2008)
Sorry, I get back to you a bit late. I am not fully understanding about Transaction Log. Let say I switched my DB Model to 'SIMPLE'. I 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
October 19, 2008 at 9:06 am
Please read the following article: http://www.karaszi.com/SQLServer/info_dont_shrink.asp
You should not shrink the transaction log on a regular basis. And no, a database backup does not back up the transaction log. ...
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
October 17, 2008 at 5:02 pm
Are you running on Vista? If so, are you trying to start the agent through SSMS? If yes, then you need to be running SSMS as an Administrator...
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
October 17, 2008 at 4:44 pm
Viewing 15 posts - 6,016 through 6,030 (of 6,676 total)