Backup SQL Server to script file in code?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lee - 12 Feb 2006 22:06 GMT

Is there anyway to backup a SQL server database to a .sql script file
through code? My provider charges me 5.00 to perform backups. I'd
like to do it on my own through code. I don't have access to the
database server machine however.

Thank you.

Signature

Warm Regards,
Lee

"Upon further investigation it appears that your software is missing
just one thing. It definitely needs more cow bell..."

Reply to this Message

Terry Burns - 12 Feb 2006 22:50 GMT

Well not exactly. However, you could query each table and return the data to
a local storage, either xml or sql.

Signature

Terry Burns
http://TrainingOn.net

>
> Is there anyway to backup a SQL server database to a .sql script file
[quoted text clipped - 3 lines]
>
> Thank you.

Reply to this Message

Lee - 13 Feb 2006 01:08 GMT

Terry Burns enlightened me by writing:

> Well not exactly. However, you could query each table and return the
> data to a local storage, either xml or sql.

That's what I figured. I need to also backup the database schema as
well. I guess I could manually iterate over all the objects and create
scripts for all that as well...

Thanks for the response.

Signature

Warm Regards,
Lee

"Upon further investigation it appears that your software is missing
just one thing. It definitely needs more cow bell..."

Reply to this Message

Peter Bromberg [C# MVP] - 13 Feb 2006 01:38 GMT

The Microsoft Sql Web Data Administrator Web app has an Export function that
does this very nicely.
Peter

Signature

Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com

> Is there anyway to backup a SQL server database to a .sql script file
> through code? My provider charges me 5.00 to perform backups. I'd
> like to do it on my own through code. I don't have access to the
> database server machine however.
>
> Thank you.

Reply to this Message

Lee - 13 Feb 2006 22:49 GMT

Peter Bromberg [C# MVP] enlightened me by writing:

> Microsoft Sql Web Data Administrator Web app

I've tried this by installing it locally and trying to connect to the
sql server over the net: no go.

I've also tried uploading the web app to my server but only get
"Required permissions cannot be acquired"

I've tried setting up the web config, but I'm not that familiar with
everything yet and am just blundering around.

Thanks anyway.

Signature

Warm Regards,
Lee

"Upon further investigation it appears that your software is missing
just one thing. It definitely needs more cow bell..."

Reply to this Message

Terry Burns - 14 Feb 2006 07:15 GMT

You need to contact your service provider for details of what you need to do
in order to get access to the server.

Signature

Terry Burns
http://TrainingOn.net

> Peter Bromberg [C# MVP] enlightened me by writing:
>
[quoted text clipped - 10 lines]
>
> Thanks anyway.

Reply to this Message

Backup SQL Server to script file in code?

Free Magazines