What do you mean by deleted?

Do you have the backup jobs set for overwrite?

Do you have the backup files set to expire?

-SQLBill

I personally don't like 3rd party software backing up my SQL Server databases. I've encountered problems in the past. What I do is a SQL Server backup to disk, then...

First, SQL Server does not STORE the DATETIME data type in ANY format.

It does store it as an 8 byte value. 4 bytes are the number of days since a...

You are INSERTing GETDATE() into a table. Is the value Date_Received a DATETIME data type or a VARCHAR?

If it's DATETIME, then format doesn't matter. SQL Server does not STORE dates...

Just give the user access to their own database and not any other database.

In Enterprise Manager, drill down to Security, expand that and click on Logins. Find the Login that...

Three thoughts:

1. any index can be dropped. Period. However, it can affect the efficiency of queries. If your queries don't/won't use the index, then dropping it will have no effect.

2....

Shas3,

The reason it took a long time was that the indexes WERE dropped and recreated. EM does a lot of stuff 'behind the scenes'.

For example, if you want to change...

CREATE CLUSTERED INDEX does cause the non-clustered index(es) to be rebuilt.

Refer to the BOL, use the Index tab, enter CREATE INDEX. Choose the option for Transact SQL. Scroll down to...

If the services run as Local System, then they can only access the 'local' server. If you want to access a network (domain), the services must be a domain account.

-SQLBill

I don't know what you mean by 'frequent' login failures. But I have had cases where I was getting login failures every second for a single login. It turned out...

Couple of thoughts:

Have you checked the Windows Event Viewer logs for error messages at the time of the crashes?

Are the backup files being copied from disk to tape? If so,...

Also, make sure you have the appropriate licenses. You are setting up an Active/Active cluster (3 instances on each node). That means you have to have a license for each...

Where are you backing up to - tape or disk? If disk - local or network?

-SQLBill

Yes.

1. Check the logins that SQL Server services use. These need to be Domain accounts with access to the network drive/directory.

2. Run the backup job using the full UNC path...

Alvin,

Log files don't have indexes.

Check out the BOL for information on:

DBCC DBREINDEX

DBCC INDEXDEFRAG

-SQLBill

BOL: Books OnLine = Microsoft SQL Server's Help

Found at Start>Programs>Microsoft SQL Server>Books OnLine

Installed as part of the Client...