Okay, I am a web developer who does a lot of data-driven interactivity. I need to create a developmental database for a customer, and I would then like to copy that database into the production database. I have made numerous inquirees in the past regarding this, and I'm hoping that someone else out there has overcome this problem. I have seen the article http://www.servergrid.com/support/article.aspx?id=13975 about Backing up and restoring MSSQL databases. It states that SSIS is the preferred method, but it gives no instructions on how to USE SSIS. I am using the SQL 2005 server, and I am using the commercial version of SSMS.
The best I can figure is that when I use the backup utility from within SSMS, it makes a backup on the ServerGrid system, without making a backup on my office network. Does anyone know how to make a local backup of a servergrid DB? Also, does anyone know how to restore a ServerGrid DB from a local file?
Any help at all would be great! Thanks!