| 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' |
Permalink | 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 |
- edit /etc/nsswitch.conf
- find the following line:
hosts: file mdns4_minimal [NOTFOUND=return] dns mdns4 - Change it to:
hosts: files dns
Permalink | Irish Blessings | 05/20/10 : Life |
May you never lie, steal, cheat or drink.
But if you must lie, lie in each other's arms.
If you must steal, steal kisses.If you must cheat, cheat death.
And if you must drink with your friends.
May the road rise up to meet you
May the wind be ever at your back.
May the sun shine warm upon your face and the rain fall softly on your fields.
Permalink 
XML Feeds