Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Backing Up Sql Databases
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01213442
Message ID:
01214268
Vues:
11
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform