Posted by DataPro on 10/02/42 11:48

Here is what the vendor is recommending:

1. Back up db and log via Windows Explorer or normal db backups
2. Stop services (application...EAS)
3. Disconnect/detach database
4. Delete log via Windows Explorer
5. Reconnect/reattach database.....log will dynamically be allocated

Does this make sense?
They also want autoshrink turned on but its my understanding some SQL
DBA's don't want that. Your thoughts?

Thanks in advance.

• Next in forum: Hanging during READ_COMMITTED_SNAPSHOT ON
• Prev in forum: Re: Timeout errors
• Thread view: Re: Question on Transaction Log Backups

[Reply to this message]