4.26.2010

SQL Backup from Command-line

http://stackoverflow.com/questions/880487/sql-server-command-line-backup-statement

@echo off
echo -- BACKUP DATABASE --
set /p DATABASENAME=Enter database name:
set DATESTAMP=%DATE:~-4%.%DATE:~7,2%.%DATE:~4,2%
set BACKUPFILENAME=%CD%\%DATABASENAME%-%DATESTAMP%.bak
set SERVERNAME=your server name here
echo.
sqlcmd -E -S %SERVERNAME% -d master -Q "BACKUP DATABASE
[%DATABASENAME%] TO DISK = N'%BACKUPFILENAME%' WITH INIT , NOUNLOAD ,
NAME = N'%DATABASENAME% backup', NOSKIP , STATS = 10, NOFORMAT"

4.13.2010

Umbraco : Pixlr

 http://our.umbraco.org/projects/pixlr