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 |
|
sqlserverdeveloper
Posting Yak Master
243 Posts |
 Posted - 2008-02-16 : 15:03:50
|
| I am having an issue with one of the db(DAReporting) which is based on desktop authority application, the Recovery model of that database keeps changing from Full to Simple, I checked all the sql jobs in that server none of the jobs are doing that. What will cause that, I am trying to find out how it's changing and how to fix that. Any help is greatly appreciated. Thanks!! |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-16 : 15:46:00
|
| Trace it in profiler to find out what's going on. |
 |
|
|
Donald Murphy
Starting Member
5 Posts |
Posted - 2008-02-25 : 18:11:14
|
| I had an issue where I couldn't change the recovery model via Enterprise Manager (or SSMS). Actually, I could change the setting but it would never save the changes. So, when I viewed the properties again the setting was back to it's original value.I ended up using ALTER DATABASE 'My DB' SET RECOVERY [RECOVERY MODE] and it worked fine. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-25 : 20:19:52
|
| Sounds ssms is not in same version with sql engine. |
|
|
|
|
|
|
Recovery model of the database keeps changing