Scheduled Backup for SQL Server express

Has anyone developed a script (that they're willing to share) that does a
scheduled backup of a SQL Server Express database and that automatically
generates a "dated" backup file - i.e. a new backup file each day as opposed
to a single one that gets overwritten?
Thankshttp://www.sqldbatips.com/showarticle.asp?ID=27
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sam Malone" <the_sam_malone@.hotmail.com> wrote in message
news:%23keAXwcdGHA.4932@.TK2MSFTNGP03.phx.gbl...
> Has anyone developed a script (that they're willing to share) that does a
scheduled backup of a
> SQL Server Express database and that automatically generates a "dated" bac
kup file - i.e. a new
> backup file each day as opposed to a single one that gets overwritten?
> Thanks
>|||Thanks VERY much, Tibor.
I haven't tried this yet but, at a glance, it seems to be exactly what I
need.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OkGImYddGHA.2456@.TK2MSFTNGP04.phx.gbl...
> http://www.sqldbatips.com/showarticle.asp?ID=27
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Sam Malone" <the_sam_malone@.hotmail.com> wrote in message
> news:%23keAXwcdGHA.4932@.TK2MSFTNGP03.phx.gbl...
>|||Jasper is the one who deserves the credit. :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sam Malone" <the_sam_malone@.hotmail.com> wrote in message
news:OiUWvThdGHA.536@.TK2MSFTNGP02.phx.gbl...
> Thanks VERY much, Tibor.
> I haven't tried this yet but, at a glance, it seems to be exactly what I n
eed.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n message
> news:OkGImYddGHA.2456@.TK2MSFTNGP04.phx.gbl...
>

Schedule query results to file...

Hi there.
I have many needs. One of these happens to be a requirement to set up a
scheduled task which calls a simple stored procedure and then sent the
resulting record set to a file - preferably in .csv format.
Anybody any ideas how to go about this? My stored proc is very basic (select
* from...) so there's nothing fancy with the resulting records it returns...
.
Any help would greatly appreciated!
All the best,
LenCreate a DTS package that execute the sp and schedule it.
AMB
"len" wrote:

> Hi there.
> I have many needs. One of these happens to be a requirement to set up a
> scheduled task which calls a simple stored procedure and then sent the
> resulting record set to a file - preferably in .csv format.
> Anybody any ideas how to go about this? My stored proc is very basic (sele
ct
> * from...) so there's nothing fancy with the resulting records it returns.
...
> Any help would greatly appreciated!
> All the best,
> Len|||use osql with output file
"len" <len@.discussions.microsoft.com> wrote in message
news:F20E1C59-A4C7-433A-822F-9153B74B0E5C@.microsoft.com...
> Hi there.
> I have many needs. One of these happens to be a requirement to set up a
> scheduled task which calls a simple stored procedure and then sent the
> resulting record set to a file - preferably in .csv format.
> Anybody any ideas how to go about this? My stored proc is very basic
> (select
> * from...) so there's nothing fancy with the resulting records it
> returns....
> Any help would greatly appreciated!
> All the best,
> Len