![]() ![]() So new installation, so SQL 2012 express and not working I hope you are fine? I just test it last week for the first Webcenter installed in Indonesia Configuration of the task itself is completely up to you (e.g.: when to be triggered etc).Open the Task Scheduler via the Start Menu > All Programs > Administrative Tools > Task Scheduler.The last step is adding your batch file to the Windows Task Scheduler: A log file is written in a location of your choice. Using the "sa" user and the default sa password, your SQL server script will be launched and a full backup will be created. Specify the server and instance where your database is located. Explanation of the bat file : Specify the password for the "sa" user, this password is set to the default sa password during the installation of Microsoft SQL Server, by default.Osql -U sa -P %saPwd% -S %server% -i C:\Esko\WCR_Backup\Full_Backup_SQL.sql -o C:\Esko\WCR_Backup\Logs\backup.log ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |