Someone once said or wrote “When there is a will, there is a way.” This is the information age and we are dealing with professional information thieves/organizations. Just like the...

Santosh, If you have not already done so, check to see what jobs are running every two weeks and run traces against these jobs. Recycle the SQL Server Logs more...

Incubus Online,

Before you do anything else, save the package as a different DTS package. Then...

Two things to change within the DTS:

Go to menu > package > Disconnected Edit then go...

Here is a script that I got from this web site to backup all the databases. If your running the same script on all the databases, create a procedure and replace...

Hello,

While in the Enterprise Manager, go to "Register SQL Server Wizard.” (Either right click on a server icon and choose “New SQL Server Registration” or go to the MMC tools menu...

Hi Dan,

Again, first backup your database, then try this:

Use Master

GO

-- Truncating the transaction log

BACKUP LOG <Database Name>

WITH

TRUNCATE_ONLY

Use <Database Name>

GO

-- Shrink Physical File:

DBCC SHRINKFILE ('<Database Logical Filename>', TRUNCATEONLY)

I thought I found this script on this website. Below is a script that can be run against the server to get the fixed drive total space:

CREATE PROCEDURE sp_diskspace

AS

SET NOCOUNT...