I believe Job will fail...

and don't configure to repair it because sometimes your db may with single user mode.

You can corrupt the table in a db manually and test it.

You...

The user which can create proc. may be the member of some other role which has higher access.

One month or one week should be fine depends on the data size...

Make sure you have the index on time column and you have enough allocatted free space in db...

You said db growth 10 times but you didn't mentioned which file data/log grew?

Your db might be in FULL recovery mode...

1. Create a server list on Report server and create table RestorHistory_All  table as RestorHistory table with one additional column server name.

2. create a procedure get the restorehistory into a...

Are you using History Cleanup task in your Maint.  plans?

If yes...check..

http://msdn2.microsoft.com/en-US/library/ms139794.aspx

MohammedU

Are you using History Cleanup task in your Maint.  plans?

If yes...check..

http://msdn2.microsoft.com/en-US/library/ms139794.aspx

MohammedU

As Robert mentioned you can give any extesion to it.

When you get the backup file from some one else, it is always better to run RESTORE HEADERONLY command to check...

Most of the configurations are dynamic in SQL2005 but this server name change is not dynamic...

May be in next release

Just create a job on your developement server to run the restore.

Step1: Kill the connections in restoring db.

Step2: Run the restore command.

Step3: Create/Sync the db users...

MohammedU