Is it possible to create a VBscript to backup a SQL database?
Using the SQL backup in SQL Express 2008 R2 I was able to generate the following script and I would like to turn it into a VBS:
BACKUP DATABASE [db] TO DISK = N'D:\db' WITH NOFORMAT, NOINIT, NAME = N'db-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
As a final result I would like to add the VBS to Windows scheduler every 15 min. Is this a safe way to do it since my database is only 40mb, expecting it to grow maybe to 200 over the next year or two?
Lastly, I am wondering when the script creates this file, will I be able to just copy the backed up file and attach it to my development server without doing import/export?