0

I am allowing guest users to log onto my database and so I want to restore the database once a week to wipe it of the quest users details, etc.

I am using SQL Server 2008 R2 Express. This version does not have Jobs.

Is it possible to automatically resotre the database without the use of a job?

TreasaNGC
  • 62
  • 1
  • 10
  • Well my friend any command cannot trigger itself, We will need a job or scheduler to do this triggering work so that the script is executed and your task is completed. – Murtaza Mar 04 '14 at 09:34

2 Answers2

2

You could use a Windows Scheduled task, which executes sqlcmd and makes the necessary RESTORE DATABASE calls.

carlpett
  • 12,203
  • 5
  • 48
  • 82
0

Use Batch File

Write the sequel Command Which will Execute the restore operation Using batch file

Then Using Task scheduler trigger automatically that batch file to run whenever neccesery.

SAT
  • 647
  • 1
  • 12
  • 23