Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Need to create a table that tracks restore/backup

Author  Topic 

pras2007
Posting Yak Master

216 Posts

Posted - 2009-05-17 : 11:56:43
Hello All,

I get several requests to restore/backup certain databases thru out the week. What I want is a table that keeps track of the entire request I get to restore/backup certain databases. Does anybody knows what attributes or tables are needed to be able to track the request? Below are list of attributes that I can think of:
- Request_ID
- Environment
- Database_Name
- Project_Name
- Requestor_Email_Address
- Date_Time_Request_Received
- Server_Name
- Restore_Date
- Envirnoment_Start_Date
- Envirnoment_End_Date
Please advice.
Thanks.
   

- Advertisement -