Re: Backup SQL Server to script file in code?

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.

--
Warm Regards,
Lee

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

Relevant Pages

  • Re: looking for way to include many times some .py code from anotherpython code
    ... data is read from mysql and presented ... > The underlaying data at some time point go into sql tables. ... > it into xml and present on web/. ... > I don't want to invent the database schema in bsddb in python. ...
    (comp.lang.python)
  • Re: looking for way to include many times some .py code from anotherpython code
    ... >> obtained from web interface and write subsequently into sql (for example, ... >> of some object and let something magically constrcut the XML tree for me. ... and strored into mysql. ... I don't want to invent the database schema in bsddb in python. ...
    (comp.lang.python)
  • Re: Backup erros
    ... You may have a SQL ... Error 800423f4 appears in the backup log file when you back up a volume by ... > Reason: The process cannot access the file because it is being used by> another process. ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS2003, NTBackup-Fehler
    ... Windows Server 2003 to resolve some VSS snapshot issues ... Backup fails on a computer that is running Small Business Server 2003 ... Die Sicherung kann nicht fortgesetzt werden. ... Microsoft OLE DB Provider for SQL Server ...
    (microsoft.public.de.german.backoffice.smallbiz)
  • RE: SQL 2005 Failing Backups Because it Exits The Query Prematurely
    ... it might be a behavior change in SQL 2005. ... SQL 2005 Failing Backups Because it Exits The Query Prematurely ... This same application (which uses ODBC) is able to backup SQL 7.0 and SQL ...
    (microsoft.public.sqlserver.odbc)