backup Database dosent inlcude triggers?

[JazzMaan]

I have backed up a db and restored it to a diff sql server 2000.

I dont see any triggers restored.

Is it true that triggers dont get exported with a complete backup, and need to manually scripted out ?

Are there any other objects that I need to manually export ?

Thanks

 

[mrdenny]

When you backup the database all objects are backed up.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com