If you only have 4-5 days of history, then you need to increase the # of rows to retain on that same screen.

We had performance issues after upgrading to 2005. Some of them were resolved after closely looking at the joins and finding we needed to modify or add the CONVERT functions...

A simpler, but less robust method would be to:

1) Take a backup to MyDatabase.BAK

2) Create a BAT file to copy MyDatabase.BAK to the target server

3) Run a T-SQL script to...

Perhaps the OP means that in addition to the "best practice" backup strategy they are following, they would like to...

What error do you get ?

You could set up a server side trace on that database ?

Solution found. Posting it in the off chance anyone cares.

This didn't really end up being relevant to SQL, but I needed a "/b" in the COPY to prevent an end...

I don't know why, but my 2 thoughts are:

1) Job 1 can be configured to start job 2 as the last step, to eliminate timing issues.

2) Why do you keep...

Quite right. I have been guilty of this in the...

I would try letting replication handle the deletes. If your replication job runs frequently, maybe it won't have a negative impact.

Anamika (10/17/2010)

Before going for a live data base what are the things we need to consider and steps should be taken as a vibrant intuitive DBA?

On memory utilization, space, Performance...

Do you want the deletes to happen at the subscribe too ? If you stop replication, and want the subscriber to be deleted too, then you'll have to reinitialize the...

Make sure you have frequent transaction log backups running, or your .LDF will grow quite big.

I do a similar process to those mentioned above. You can use a loop with...

Backup Device ?

Sorry, I haven't used OUTPUT so I don't quite follow how that would help. (reading up on it now)

I should clarify, that TableA that data is being selected from is...