Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Backing Up Sql Databases
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01213442
Message ID:
01214268
Views:
9
>Is there any solution where I can have an icon on the desktop, or a scheduled event , of some sort.

Perry Foreman pointed me to this, which I have found to be very helpful...

http://www.sqldbatips.com/showarticle.asp?ID=27

It helps to understand SQLCMD along with the above. You can view some old webcasts free from the links below (the first one, by Michiel Wories, was far better IMO).

http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?culture=en-US&EventID=1032275435&CountryCode=US
http://www.microsoft.com/events/EventDetails.aspx?CMTYSvcSource=MSCOMMedia&Params=%7eCMTYDataSvcParams%5e%7earg+Name%3d%22ID%22+Value%3d%221032290603%22%2f%5e%7earg+Name%3d%22ProviderID%22+Value%3d%22A6B43178-497C-4225-BA42-DF595171F04C%22%2f%5e%7earg+Name%3d%22lang%22+Value%3d%22en%22%2f%5e%7earg+Name%3d%22cr%22+Value%3d%22US%22%2f%5e%7esParams%5e%7e%2fsParams%5e%7e%2fCMTYDataSvcParams%5e

Armed with the above, you can create jobs that run in the Windows Task scheduler to automatically run a backup and do other maintenance routines without purchasing 3rd party software. I've done it and it works.
Del
Previous
Reply
Map
View

Click here to load this message in the networking platform