Monthly Archives: October 2008

Fix user mapping after restoring database to another server instance

Often when you restore a backup from SQL server you run into funky problems with users. Suppose you have login calvin and you restore a database from another server that already has user called calvin. When you try to map … Continue reading

Posted in SQL | Leave a comment

xcopy

echo —————- >> c:\backup_log.logecho \calvin\*.* >> c:\backup_log.logxcopy d:\calvin\*.* "\\192.168.1.99\F$\calvin-backup\calvin\*.*" /H /D/E /C /R /Y>> c:\backup_log.logtime /t >> "c:\backup_log.log"

Posted in Sys Admin | Leave a comment