SQL backup solution

With SQL Manager, tick the box to export blobs as strings.

--
Jules
http://www.charon.co.uk/products.aspx
Charon Cart
Ecommerce for ASP/ASP.NET


"Square Eye" <contact@squareeye.com> wrote in message
news:firlsr$6f9$1@forums.macromedia.com...
> Thank you both very much! A couple of follow-ups if you happen to read
> this...
>
> EMS SQL Manager - I downloaded this and seem to have backed up my database
> fine as a SQL script, plus a .blo file for blob data. (a) Out of
> curiosity,
> why does it give the option /not/ to export blob data - this is most of
> our
> database's most important content - worried I'm missing something? and
> (b) as
> a novice asking, how would I then restore from these .sql and .blo files
> to my
> remote database, if I needed to?
>
> Enterprise Manager - I downloaded and installed this, many thanks for the
> link. But if I try and use the DTS Import/Export wizard to backup to my
> local
> machine, it fails to connect to my local SQL Server - seems to be unable
> to
> connect to SQL Server 2005 and tells me to use SQL Server Management
> Studio
> instead. Does this mean I would need to uninstall SQL Server 2005 and
> install
> SQL Server 2000 locally instead?
>
> Thanks!
>
> Square Eye
>

Thank you both very much! A couple of follow-ups if you happen to read this...

EMS SQL Manager - I downloaded this and seem to have backed up my database fine as a SQL script, plus a .blo file for blob data. (a) Out of curiosity, why does it give the option /not/ to export blob data - this is most of our database's most important content - worried I'm missing something? and (b) as a novice asking, how would I then restore from these .sql and .blo files to my remote database, if I needed to?

Enterprise Manager - I downloaded and installed this, many thanks for the link. But if I try and use the DTS Import/Export wizard to backup to my local machine, it fails to connect to my local SQL Server - seems to be unable to connect to SQL Server 2005 and tells me to use SQL Server Management Studio instead. Does this mean I would need to uninstall SQL Server 2005 and install SQL Server 2000 locally instead?

Thanks!

Square Eye

I tend to use SQL Manager

http://www.sqlmanager.net/

You can save entire databases as a script locally. I'm pretty sure it can be
scheduled too.

--
Jules
http://www.charon.co.uk/products.aspx
Charon Cart
Ecommerce for ASP/ASP.NET

What is your end goal? To develop locally or to just backup the database?

Enterprise Manager is part of the SQL Server 2000 suite.

Downloads for SQL Server:
http://technet.microsoft.com/en-us/sqlserver/bb331729.aspx

If I remember correctly, the evaluation download only works for 120 days, but enterprise manager never stops working and you can use it.

http://www.microsoft.com/downloads/details.aspx?FamilyID=d20ba6e1-f44c-4781-a6bb-f60e02dc1335&DisplayLang=en#QuickInfoContainer

Within Enterprise Manager, you should add another scheduled maintenance that backup all the databases to a drive you do have access to. If you don't have these kinds of permissions/privaledges from your host because of the type of webhosting you use, then tell them what you want to do... it's not hard for them to set this up.

Hi

Dooza - it's SQL Server 2000, yes, and I have a local version running. But I don't have Enterprise Manager, which seems to be discontinued (?). Instead I have SQL Server Management Studio, which doesn't seem to have DTS, and allows exporting table data, but not the stored procedures etc.

Jsteinmann - sadly I don't have FTP access to the SQL Server backup area, just access to the database itself - restriction of this particular security-conscious host. I do make Access backups but they seem to drop all the stored procedures, primary keys, etc. etc.

Thanks!

Square Eye

Run a daily maintenance plan that backs up all of your databases to a specific spot on one of the servers drives that you have ftp access to, and just access it when you feel the need to download it to your computer or setup an FTP program that does it automatically for you. You can also export into an access database if you'd like a working copy for yourself for development purposes on a local machine.

Square Eye wrote:
> Hello
>
> Sorry, slightly off-topic but can anyone recommend a good solution for backing
> up a MS SQL database? I've found several options which do some of what I want
> to do, but not all, which is:
>
> - backup from remote SQL database, for which I have IP address, username and
> password (on third-party host)
> - save to local drive
> - include database schema, stored procedures etc (and avoid primary keys
> dropping off tables!)
> - automatic scheduling
>
> Any pointers would be very gratefully received!
>
> Thanks
>
> Square Eye
>

Which version of SQL are you running? Do you have a local version
running? Do you use Enterprise Manager?

You could set up a DTS package in SQL 2000 which has built in support
for copying entire databases, you could run that locally to pull the
remote database into the local one.

I am sure there are many commercial products about as well.

Steve