This is SQL 7, the recovery mode is set to 'Select into/bulk copy', it should not be a problem, the third-party agent can do the transaction log backup without problem,...

I unchecked 'auto close' option on the database property, it is SQL 7, but it is still showing me a lot messages on opening and closing the database files....

Create the login stored procedure and produce it on the source server, generate the result script on the target server. Check this link.

http://support.microsoft.com/default.aspx?scid=kb;en-us;q246133

Steve,

Will the log size be increased if I uncheck the auto close option?

This link will be helpful on oracle issue.

http://forums.dbasupport.com/forums/

Again since my boss does not want to spend much money on the third party tools, I will try it on my own, but there are too many tables, so...

Can T-SQL do it since third party tool is not possible for me now.

I tried DBCC log(DB name), I don't understand the result.

Basicly I am looking for the way to view the transaction log.

sql server could not be started after restore master, the message showed successful restore, few second later, 'sql server connection broken' message popup, I tried serveral times on SQL2000 SP2...