This weekend,

I took the database full back up.

I took transaction log back up.

Issued the "CHECKPOINT" command and changed the recovery mode to simple.

Shrinked the transaction log.

Changed recovery...

It came back.It took one hour and 45 minutes.

What is the best way to do reindex on such a large table?

the above script is throwing an error  at line " exec @result =xp_cmdshell @Pdy"

The error : "Incorrect syntax near the keyword 'exec'."

Any solution would be really appreciated

I would appreciate if you can briefly explain, how can i accomplish this?

My requirement is to take tha backup and keep the 7copies for last 7 days. We have to move each backup file to the network file-server automatically.

Can this be accomplished...

Problem...!!!

the above script is throwing an error  at line " exec @result =xp_cmdshell @Pdy"

The error : "Incorrect syntax near the keyword 'exec'."

Any help would be greatly appreciated.

Hey, thanks to both of you. Both the otions looks very good to me. The advantage of the first one is that you just have to schedule the script, no...

I posted this question in the 'BACKUP' section then i reliazed that T-SQL is the better place to post my question. Apologize for any inconvenience.