Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Ashok_S
Starting Member
5 Posts |
 Posted - 2005-08-18 : 07:56:26
|
| For the past couple of weeks, the particular database is automatically detached from sqlserver especially during after 11 PM(when datbase is not in use) . That too not daily .., but frequently. Is there any idea to what has actually happened for the detachement.No defrag software running. Viruses not found - checked properly.We had executed the command only DBCC shrinkfile reduced from 672 Mb to 30.1 mb for Log file.Does the DBCC shrink file to 30 MB would have any impact on the database ?Any suggestionsPls Help |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-08-18 : 08:04:19
|
| shrink file causes fragmentation. Why are'nt you just backing up your log files like you should be (which truncates them).as to your problem my bet is somebody has a job running that uses sp_dettach_db to copy the the database to another server and they are forgetting to reattach to the orginal server after the copy. this is not a 24/7/365 enviroment, is it?====================================================Regards,Sean RoussyThank you, drive through |
 |
|
|
Ashok_S
Starting Member
5 Posts |
Posted - 2005-08-18 : 08:12:07
|
| yaIt's not a 24/7/365 environments.We work only in the day time.We does not copy the db to another server.It was there previously.Now its removed.Thx. |
|
|
|
|
|
|
DB Gets Detached