Ok, if anyone can help it would be appreciated.
im mulling over whether to use MySQL or SQL server for database
development on web applications. Basically i had always used access
but now that we have decided to take on bigger projects i feel i need
something more robust for multiple transactions.
at the same time im concerned about price of sql server - the most
important facility that i need is an easy to use back up tool that i
can schedule which i believe is not built into the express edition.
so basically im wondering what version or type of sql server that i
need to put on a webserver so that i can have multiple clients on the
same instance. also how many licences do i need if i have this type of
setup ???
any links or help would be appreciated as im new to this.
Thanks
Colin
>Ok, if anyone can help it would be appreciated.
>at the same time im concerned about price of sql server - the most
>important facility that i need is an easy to use back up tool that i
>can schedule which i believe is not built into the express edition.
>Colin
There is a web page or two out there showing you how to use the SQL
server express management suite to create a backup script, which you
can then use windows task scheduler to execute.
Tibor Karaszi - 09 Jul 2008 20:49 GMT
> There is a web page or two out there showing you how to use the SQL
> server express management suite to create a backup script, which you
> can then use windows task scheduler to execute.
You're probably thinking of sqldbatips.com.

Signature
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
>>Ok, if anyone can help it would be appreciated.
>
[quoted text clipped - 7 lines]
> server express management suite to create a backup script, which you
> can then use windows task scheduler to execute.
Try SQLExpress.
Cost $0.
Use the WIndows Task Scheduler to run a simple backup script.

Signature
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP
> Ok, if anyone can help it would be appreciated.
>
[quoted text clipped - 17 lines]
>
> Colin