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 |
|
jeanh
Starting Member
20 Posts |
 Posted - 2005-03-09 : 11:40:52
|
| I am trying to execute the following command:alter database my-database set recovery simpleand it appears that since my database name has a hyphen in it the command fails. Is there any way to overcome this? I tried putting single quotes around the database name and I also tried putting parentheses around the database name. Any ideas? Thanks, JeanJean Holland |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-03-09 : 13:50:48
|
try ALTER DATABASE [my-database] SET RECOVERY SIMPLE -ec |
 |
|
|
jeanh
Starting Member
20 Posts |
Posted - 2005-03-09 : 14:26:21
|
Hurray! Thanks for the advice. It worked. Jean Jean Holland |
|
|
|
|
|
|
Recovery Mode