RS First Dynamics NAV Blog


...from NAV 3.60 to NAV 2013
Home Blogs | Home | Login | Contact | My Profile | RSS | About | Cerca

Microsoft solution to automate backup on SQL Express

Microsoft solution to automate backup on SQL Express(SQL Server Agent is not available on this SQL release)Microsoft Solutionhttps://support.microsoft.com/en-us/kb/2019698Sample Backup.cmd filesqlcmd -U sa -P xxxx -S .\SQL2012EXPRESS -Q "EXEC sp_BackupDatabases @backupLocation = 'C:\SQLBackups\', @backupType = 'F'"You can schedule jobs with standard "Windows Jobs" 
Leggi tutto il post...
Categoria: Sql Server ALL
sabato, 18 apr 2015 Ore. 17.31

Scrivi un commento


Non è possibile inviare commenti a questo Blog

Commenti

Copyright © 2002-2007 - Blogs 2.0
dotNetHell.it | Home Page Blogs
ASP.NET 2.0 Windows 2003