In ur SSMS, Go to SQL Server Agent -> Jobs

right click jobs -> click Tasks -> Generate Scripts.

Once u've your scripts ready, run those on ur target DB after u've...

refer BOL

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/f82d6918-a5a7-4af8-868e-4247f5b00c52.htm

example-

backup database northwind to disk='d:\backupwind.bak' with copy_only

The only difference is it doesnot reset the LSN during its backup procedures; which means id u're taking an ad-hoc request of...

Thanks Prajapati for writing this code. I tested DDL triggers for the first time 😉

i'd to do few modifications for it to run in this line... ...

You can do as Gail suggested OR you can build a DLL with your encryption/decryption logic and add it to ur SQL Server as extended stored proc and use that...

You may want to look at this URL. contains code to delete files in a folder. you may want to do little twicking to delete certain files only.

http://www.sqlservercentral.com/articles/Administering/usingxp_cmdshell/1250/

use xp_cmdshell to fire OS level commands.

xp_cmdshell 'del c:\testfile.txt'

make sure xp_cmdshell is enabled at Sql Server 2005 surface area configuration.

Well i'm already addicted to this forum. hardly 3 weeks here and yet i've learnt so much!! There is no end of learnings here. One doesn't need to go anywhere...

Thanks Jeffery for making it so clear.

The easiest method to implement is a SQL Agent job that runs every XX minutes/hours and checks for database creation. When found,...

How about writing a simple backup statement at the end of database creation! the other point i mentioned in initial posts. I think that should do the needful for first...

this should help you.

http://www.sql-server-performance.com/articles/dba/creating_backup_jobs_p1.aspx

Contains description of creating backup jobs through t-sql and ssms.

The sp sp_dba_DAC created without any issues and is giving desired results when fired from within the SSMS.

However i'm unable to fire it from using sqlcmd. Getting following error:

HResult 0xFFFFFFFF,...

i'm sure u're not physically going for db creation either. You can create your database from you location(provided the new location is on network and you've appropriate rights).

Taking a backup...

Use ALter database with Modify file option to move the tempdb database and do an instance restart.

FOllowing links would be helpful.

http://www.sqlservercentral.com/articles/Administration/63568/

http://support.microsoft.com/kb/187824

or in BOL

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/72bb62ee-9602-4f71-be51-c466c1670878.htm

Why would you want to backup a database within a trigger?

You can manually fire the backup statement after you create the database OR if you've a script to create a...

Thanks Manu. I'll try these options. And ya, the sql server is running all the time.