SQL Tools - suggestion

The new SQL Tools are great! I've successfully backed up my DB, ftp'd the file to a local machine and restored it without incident.....great for doing local development with real-world data.

Ideally, I'd like to have a local copy of my DB for back up purposes. Have you given it any thought to have the "Create A Backup" run as a scheduled task and simply overwrite the existing file in the root?That way I could ftp the backup file automatically on a regular basis.

Great job on the tools so far!

Arby

 

Arby,


How did you accomplish restoring the backed up file to your local sql server? I've also ftp'd the backup copy to my local machine, but keeping getting an error when trying to restore (SQL2005 Developer)because of the unique database name given by DiscountASP. Renaming the backup file to the actual database name does not seem to work. I would also like to do further development against real-world data.

 

In the Restore Database wizard in SQL Management Studio, make sure that you go to Options and modify the paths of the MDF and LDF files to the data folder on your computer.

Aristotle

DiscountASP.NET
www.DiscountASP.NET