How do I back up a database from ServerGrid.com?
I have a hosting account with servergrid.com. I want to backup my database, they say I have to use Sql Server Integration Service to back up my database and I need commercial version of Sql Server management studio.
I have Sql Server 2005 Developer Edition. I have no idea how to back up SSIS. I tried playing with the Sql Server Integration Services project in VS2005 .. but I couldn't.
Google also doesn't seem to have a step-by-step guide for non-DBAs like me.
Can anyone point me / write me step by step instructions on how to back up a database using SSIS? and also, if possible, how to restore the database back to the host
source to share
SSIS is not a database backup tool.
If you have a fixed number of tables, you can export data from SQL Server to comma-separated or raw files - i.e. export data using SSIS. It is easy to create such a package using an SSIS project if you have a small number of tables. But if you have a lot of tables, this is all a manual process. It can also be tricky to automate this - every time you add / delete / modify a table or column, you need to restore the SSIS package used to export your data.
SSIS only exports data, so you need a separate tool to back up the metadata (tables and stored proc definitions). You can export metadata using Management Studio (just script the database to a text file).
It is possible to combine these two tools together with a poor man's backup tool, but if you change metadata frequently, you probably want to use a real SQL backup tool. Not sure why the hosting guys say you should use SSIS - they might not want to give you backup permissions to keep the database secure, but SSIS isn't the easiest way to back up your database.
source to share
You have a local drive on this computer, right?
Access sql prompt through your tools or sqlcmd .
BACKUP DATABASE MYDB TO DISK = 'E: \ backups \ mydb.bak'
Then the FTP file is outside the site.
Otherwise, forget these creeps that will force you to use SSIS to perform tasks that can be done with a single line of text.
source to share