Create a Full Database Backup In SQL Server

Create a Full Database Backup In SQL Server

BACKUP DATABASE DataBaseName TO DISK = 'D:\BackupName.bak'
Example
DataBase name:DbPabitra
BACKUP DATABASE DbPabitra TO DISK = 'D:\DataBaseBacup.bak'
For More Informatation
http://pabitramicrosoftresearch.blogspot.in/

DDL TRIGGER FOR ALL DATABASE CREATE,ALTER,DELETE TABLE IN SQLSERVER

---For All Server(DataBase)
ALTER trigger NoTable
on all server
for CREATE_TABLE,ALTER_TABLE,DROP_TABLE
AS BEGIN
PRINT 'NO NEW TABLE PLEASE'
ROLLBACK
END