Trigger advice

[Bell1991]

I am extremly new to SQL Server and i am currently reading about triggers - i was wondering if i could write a trigger to back up my database (i.e., backup every night at 12). Is that possible?

Also, one final question. How do you get the server date and time - when i insert a new row - i want to also insert the database time and date.

Thanks in advance for your help.

 

[Sabnac]

To backup your db use scheduled jobs or maintenance plan.

To retrieve datetime use the getdate() function

 

[SQLSister]

And set the getdate() function as the default value rather than putting it in a trigger, that is the more efficient way.