SQL Server Backing up 1

[damipera]

Hi,

We have a website with SQL server as the database. We do not have any physical nor admin access to it. We can only do the usual- query, edit, add, delete data using .aspx.

The people who maintain our database say that they are backing up our database regularly but we also want to backup our database as well as the stored procedures. At the moment, we are doing the importing SQL server DB using MS Access. Although Access is ok but I know it's not getting all the data in the bigger text field of SQL server because Access can only hold so much data text in its field.

Do you know of other ways, we could backup the whole data of our SQL server?

Thanks for any tips.

 

[JayKusch]

What is the intent of the backup?

Is it to have a copy offisite from the host?

If not, an option would be to create another DB (lets call it archive) in the same instance and use DTS/SSIS to export from your live DB to the "archive" DB.

Another option, if you have access to a share on the server (maybe a work area the host provides you) could be to create a SQL job that backs up and restores the live DB to the archive DB.

I see that you are importing the data into Access, but does not acquire the larger data types ... could you possibly replace the Access piece with a SQL Express edition or possibly spring for Standard?

That way you could mirror your live DB on to a SQL edition at your location. You could sping the purchase of the Standard version as both a DR methodolgy as well as a possible new dev environment.

Just a couple of thoughts!



Thanks

J. Kusch

 

[damipera]

the intent was just to have a copy on our side.

thanks very much JayKusch for some tips.