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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-12-21 : 09:41:41
|
| Michael writes "MS SQL Server 2000 SP2 StandardWindows 2000 Professional (client)Windows 2000 ServerI am new to SQL Server 2000.Our accounting dept. wants to copy the financial DB prior to final month-end or year-end processes. IT is not always available when they choose to run the final processes.Can you suggest a method which allows the user to execute a secure process to create a copy of the database? They would execute the process on their own timetable prior to the final ME or YE processes.Thank you for any support you can provide." |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2001-12-21 : 10:13:10
|
| You should already have a job which does a backup. Make sure that backup is in a stored procedure then you can use the same SP.If they don't have permission to run backups or to start a job then give them a stored proc which places an entry in a table. Have a scheduled task that looks at the table every 5 mins or so and executes the backup if it finds an entry. It can delete or update the entrty on completion so that the users can check that the backup is complete.==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
User control of database copy