>Normally, how many memory we need for SQL 7.0?

As much has you can afford and the server can hold <bg>

-Mike

>
>Perhaps we could create a sp and dettach the database, make a copy of the file, then reattach the database. We could run this every evening.
>
>
>
>Thanks
>
>
>Jim