SQL Server 7 + database maintenance plan

[kaliak]

Hi,

SQL Server 7.0

I have used the "Database Maintenance Plan" to create a backup transaction log on our production server, which logs changes every 30 minutes.

Questions:
1)Is there anyway to write the changes into 1 file through the Database maintenance Plan instead of having multiple files every 30 minutes (we have multiple db on the server this way would be messy)?
2)I need to copy the transaction log from our production to our report server-can this be done thru the maintenance plan?

Thanks for any help/suggestions.

 

[mrdenny]

1) I don't think so.
2) No, that would be log shipping, which has it's own wizzard.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

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

http://www.mrdenny.com