| mac : triple monitor | 07/16/10 : Code |
| windows : easy SQL backups | 07/13/10 : Code |
Run this on each database
Code:
ALTER DATABASE database_name SET RECOVERY SIMPLE |
Create "backup_databases.sql" file
Code:
/*-------------------BACKUP EACH DATABASE-------------------*/ | |
| |
BACKUP DATABASE ABC TO DISK = 'C:\SQL_BACKUPS\ABC.bak'; | |
| |
BACKUP DATABASE MNO TO DISK = 'C:\SQL_BACKUPS\MNO.bak'; | |
| |
BACKUP DATABASE XYZ TO DISK = 'C:\SQL_BACKUPS\XYZ.bak'; |
Create "run_database_backup.bat" batch file
Code:
sqlcmd -S server\instance -i C:\pathto_sql_file\backup_databases.sql |
Run the batch file as a scheduled task.
-------------------------------------------------
To Restore
Code:
RESTORE DATABASE database_name FROM DISK ='C:\SQL_BACKUPS\database_name.bak' |
| mac : DMG to ISO | 07/09/10 : Code |
hdiutil convert /path/to/filename.dmg -format UDTO -o /path/to/savefile.iso
| linux : ubuntu "cant ping fqdn" fix | 07/02/10 : Code |
| Irish Blessings | 05/20/10 : Life |