Hi list. Another 'logic' question of sorts I guess.
I use public-hosting for SQL Server and CF on NT. I asked my server
people how much they'd charge for making me a physical disk of my
datasource backup, regularly (I thought sql server had a feature to
do that) but they won't offer that option. They suggest I back it up
myself.
I could set up a query to write contents of every table to a text
file; I'd have delimiter problems (it's a math edu site so every char
on the keyboard is likely to be in content and/or in Q&A responses),
but it's doable. But, that's a huge job considering the many tables,
and it seems like it would draw server resources which aren't real
sparing on public servers to begin with.
I could do the same process but writing to an Access .mdb file I
suppose; but access doesn't have exactly the same fields/etc. SQL
server does (though I know they're matchable); the same issues as
above apply plus question on the replica of fields.
I'm on starband but it's much slower than DSL, so whatever is done
has to be on the server, I can't do it from where I am physically.
I looked through my SQL Server books but I don't see anything about
this (maybe I have the wrong books). Bearing in mind I do NOT have
access to the enterprise manager for SQL-S, is there any kind of
built-in function I could put in code that would simply back up my
entire datasource (including objects??) to another file or something
I'd have access to?
Best regards,
Palyne
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
