I agree with scripting all Onjects before rebuilding, but what about data. once you generate the script, it wont come with Data on the DB or any object.

Does it make...

Again it depends on your organization. How would you like to do cofig your system and your DB.

It depends on your organization and the application criticality as well.

I would recommend you the following.....

1) Full backup Daily after business hours,

2) If possible make 4hours diff. backup

3) evry 15...

I had 15 TB and it tooks me 6 hours to backup and for restoration it tooks me 3 1/2 hours from litespeed.

I am not agree with mobasha, For moving couple of table you do not have restore whole DB.

If you are using Litespeed. there is a good facility to move or...

I am in TB environemnt and I would recommed Litespeed is the best solution for that. I do not have any issue with Litespeed.

Again, If it is mission Critical application, Please go with Tape Backup Shipment.

I would recommend the Tape Backup Shipment and FTP.

Just run both the permission. It will give you some result sets. Actually that result set having to create logins with password in encryption format. You just need to copy...

Please use the Import export wiz. or else you can use the DTS/SSIS package to move the table from 1 DB to other DB in the same or else other...

As I understand, you were talking about the SQL Logs.

Truncate is not a logged operation and it will remove uncommited transaction from the Log.

Shrinking is nothing but Comprissing. If have...

Use the Third Party tools "Litespeed from QUEST". It will compress the backup upto 60-70%.

Litespeed has so many new features such as you can backup the database and keep that...

In order to come out from the messy data. You can Install new instance and restore all DB's and then applly changes as you wish. I assumed it is a...

There are couple of solutions to copy big files such as 70GB or more than that backup files and so on.

1) The Robocopy is the best solution and you may...

There are couple of solutions to copy big files such as 70GB or more than that backup files and so on.

1) The Robocopy is the best solution and you may...

It would be great i f you can run microsoft stored proc for move the logins from one server/instance to another.

After moving this you need to manually map the logins...