![]() ![]() Then create in C:\MSSQL-backup a Databases.txt file, there you can place your databases that will be done for a backup.I've just rebuilt a 486-DX machine to replicate the family PC we had from '94 to about 2000 when it was scrapped. ![]() When you have many databases you can try the following if you don't want type till you drop :įor /F %%i in (c:\MSSQL-backup\Databases.txt) do (SET DatabaseBackupPath=E:\backup\%%i Now you can create a scheduled task (if needed). Put a datestamp on the Backupfile : YYYY:DD:MM:MIN:SEC msbp.exe Backup"db(database=Master)" "gzip(level=5)" "local(path=C:\SQLBackup-Compressed\Master\)" Forfiles -p C:\SQLBackup-Compressed -s -m *.* -d -1 -c "cmd /c del /q files older then 1 day (-d -1)Ĭreate a directory where the database will Backup this will make sure the dir is there Msbp.exe Backup"db(database=Master)" "gzip(level=5)" "local(path=C:\SQLBackup-Compressed\Master\)" Install the MSBP (download HERE ) on the SQL serverĬreate a BAT file with the following data (let say c:\mssql-backup\msbackup.bat)įorfiles -p D:\SQLBackup-Compressed -s -m *.* -d -1 -c "cmd /c del /q C:\SQLBackup-Compressed\Master The rate plugin limits the impact of a Backup on your server by restricting the speed of theBackup(or restore). You can have any number of plugins in the pipeline.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2023
Categories |