![]() ![]() I also suggest to seea free tool to backup your databases Its name is SQL backup and FTP (). In windows xp and w2k3 its working fine with scheduled task 1.0.īut when i am using Windows server 2008 or vista or windows 7 there is Task scheduler 2.0 on this i am not able to set start in path.Ĭan you please help what kind of changes apply on this task scheduler 2.0 ? SQL backup and FTP is my favorite tool for sql backups I also recommend using SQL Backup and FTP, the free version lets you backup up to 2 databases daily which makes it an excellent tool for SQL Express. Msg 2812, Level 16, State 62, Server Server1, Line 1Ĭould not find stored procedure 'sp_BackupDatabase'. Though, i am able to execute this sql from SQL management studio. I have created the Stored procedure in master database ( Programability -> stored procedures ) but still i am getting the below error. We have a customer with no IT staff and SQLBackupAndFTP perfectly solved the daily backup problems, plus the free version let usto to schedule up to 2 database backups daily. Tools such SQLBackupAndFTP in most standart cases really the good choice. How to overwrite backup taken by this autobackup utility. This does not seemed to be working, please add a screen shot to show how you do the action part setting the scheduler. I put under program/script the path to run SQLCMD, under add arguments(optional), I added the sqlcmd -S. I am confused about the action part in 2008. Thanks sir.This is one of the best articles.Its working nicely for me and our clients.įollow up to my question: In Windows 2008, you need to put Sqlcmd under program/script, and add -S servername\instancename -i c:\SQbackup\backup.sql next to add arguments(optional).Ĭan you please update your note to show how you setup the scheduled task using windows 2008. Thanks a lot for this perfectly solution! It´s working fine! We are backing up the file to tape every night. ![]() In our case we just want to keep a day work the backup. I was wondering how we could change it to overwrite the existing backup files. From this Idea we can automate execution of other SPs as well, not only backup. Thanks Edgewood Solutions ! It worked perfectly beyond my expectation. This file gets saved as backup.sql and for our purposes this is created in the "C:\Backup" folder, but again this could be put anywhere. Here is a simple SQLCMD file that backups databases master, model and msdb. ' TO DISK = ''C:\Backup\' '_Log_' '.TRN'''ĮXECUTE sp_executesql second part of this is to create a SQLCMD file to run the backup commands. ' TO DISK = ''C:\Backup\' '_Diff_' '.BAK'' WITH DIFFERENTIAL' Parameter2: backupType F=full, D=differential, L=log ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |