Developer Tips & Hints

1. Maximum 10 GB per database. 2. Uses no more than 1 processor. 3. Uses no more than 1 GB of internal memory. 4. NO Maintenance plans 5. NO Database mail 6. NO User instances 7. SQL Server Agent 8. NO Full-text search

backup database TestDB to disk = 'E:\testdb.bak' with stats = 10,password ='elshan' http://www.mssqltips.com/sqlservertip/1849/backup-and-restore-sql-server-databases-programmatically-with-smo/