MSSQL Backup database - without BACKUP command
-
Hi all, I have a MSSQL database with Godaddy, and I have access using the SQL Server Managements Studio, and of course their Hosting center interface with a web browser. I need a more robust backup setup. Currently I would have to manually initiate a backup. -Is there a way to automate a backup using The Sql Server Management Studio? Perhaps from my client PC (COM, DLL)? -I can't use the BACKUP command statement as the server is attempting to create the backup file on THEIR servers. The only information I'm using the database is table data. If using .NET along with the SQL database, are there any methods (that would be reasonably affective) to SELECT statement for each table in db. Then export this database to csv or other format. Appreciate your help.
-
Hi all, I have a MSSQL database with Godaddy, and I have access using the SQL Server Managements Studio, and of course their Hosting center interface with a web browser. I need a more robust backup setup. Currently I would have to manually initiate a backup. -Is there a way to automate a backup using The Sql Server Management Studio? Perhaps from my client PC (COM, DLL)? -I can't use the BACKUP command statement as the server is attempting to create the backup file on THEIR servers. The only information I'm using the database is table data. If using .NET along with the SQL database, are there any methods (that would be reasonably affective) to SELECT statement for each table in db. Then export this database to csv or other format. Appreciate your help.
-
Hi all, I have a MSSQL database with Godaddy, and I have access using the SQL Server Managements Studio, and of course their Hosting center interface with a web browser. I need a more robust backup setup. Currently I would have to manually initiate a backup. -Is there a way to automate a backup using The Sql Server Management Studio? Perhaps from my client PC (COM, DLL)? -I can't use the BACKUP command statement as the server is attempting to create the backup file on THEIR servers. The only information I'm using the database is table data. If using .NET along with the SQL database, are there any methods (that would be reasonably affective) to SELECT statement for each table in db. Then export this database to csv or other format. Appreciate your help.
-
IMO, the only place where you can backup the databases on a server is on the server itself. What you can do is to write a script to execute the BACKUP command and FTP the file from the server to your PC/Laptop.
modified on Tuesday, May 31, 2011 7:11 AM