Viewing 15 posts - 5,476 through 5,490 (of 6,676 total)
I can think of a couple options:
1) Install SQL Server 2008 client tools, setup a folder and register your servers, then use the multi-script option to open a connection 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
March 27, 2009 at 6:40 pm
Florian Reischl (3/27/2009)
Jeffrey Williams (3/27/2009)
PS> Get-Childitem -Recurse | ? {$_.LastWriteTime -lt (get-date).AddDays(-3)} | % {Remove-Item $_.Name -Whatif}
:w00t:
So that's exactly what I'm speaking about...
Fortunately I don't have to. I'm a developer,...
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
March 27, 2009 at 2:00 pm
Florian Reischl (3/27/2009)
sqlblue (3/26/2009)
... PowerShell...Powershell? Wish you the best :-), it can do almost everything, but the syntax is just ugly in my opinion...
Greets
Flo
Ah, Flo - it's not that bad...
...
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
March 27, 2009 at 1:23 pm
I am not really sure if they meant hex or decimal.
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
March 27, 2009 at 1:19 pm
Once an index is disabled - the only way to enable it is to rebuild. Rebuilding an index that was disabled in an offline operation (meaning, the index 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
March 27, 2009 at 1:17 pm
Since you are truncating and loading every time - here is what i would recommend:
1) Disable all NC indexes
a) Leave clustered indexes enabled - or 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
March 27, 2009 at 9:40 am
I don't see any issues with the setup for this small set. When you get to loading millions of rows you are going to want to modify the batch...
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
March 26, 2009 at 4:17 pm
It sounds like you are running the SSIS package on your desktop. If so, that is going to be part of the problem.
In the OLEDB Source - are 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
March 26, 2009 at 3:07 pm
Those all look like SQL Server 2000 maintenance plan jobs. Are you on SQL Server 2000 or SQL Server 2005?
The outline I provided was based on setting this up...
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
March 26, 2009 at 1:39 pm
There is no native way to delete OS files from SQL Server. The basic options are:
xp_cmdshell - allows you to call out to the OS and issue OS commands....
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
March 26, 2009 at 1:36 pm
Basic starting point - adjust as needed...
Daily Plan (All User Databases)
Integrity Check
Backup
Remove Old Backup Files
Remove Old Transaction Log Backup Files
Daily Plan (All System Databases)
Integrity Check
Backup
Remove Old Backup Files
Hourly Plan (All...
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
March 26, 2009 at 1:25 pm
Other option could be a powershell script - sqlcmd and send the email. It really depends upon what you are doing. For anything that needs to be accessible...
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
March 26, 2009 at 1:16 pm
The real question is why do you need to do this in SQL?
Much easier to create a batch file or powershell script to delete files on a regular...
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
March 26, 2009 at 1:13 pm
To find out whether or not the data file is growing (autogrowths) you can use the Disk Usage report. Right-click on the database, go to reports and select 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
March 26, 2009 at 12:22 pm
For a good DR strategy, it has to be either tape or some other media that can be taken offline and shipped to offsite storage. Tape is generally easier...
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
March 26, 2009 at 12:17 pm
Viewing 15 posts - 5,476 through 5,490 (of 6,676 total)