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.
| Author |
Topic |
|
nerdygirl61
Starting Member
21 Posts |
 Posted - 2012-09-18 : 12:42:53
|
| This is my first year using SQL Server to create cost report. I need to be able to basically back up a snapshot of the data base on the day I run, and all the stored procecdures and functions. I also need to be able to access the snapshot at any time to pull data for auditors, etc. It would be preferable it the data could be saved as read only, so there is no chance of anyone changing it. Is it possible to save a copy of the entire database and all the stored procedures under a different name, eg DataBaseFY1112, so that I can access it at will in the future? |
|
|
|
|
|
Back up /snapshot question