Thanks for taking the time to comment =) I’m trying to get everything out of my head right now. When you look at the online documentation, the only available value for “Recovery” is FULL” This is probably because each instance of SQL Database is replicated 2 times giving a total of 3 instances at all times. I took some time to go back to a book and some documentation, and it doesn’t seem like we can change the recovery model. One of these is limiting transaction logs to 2gb, an other way it protects itself is by limiting the number of locks per transaction. The reason I limit the number of rows, is because SQL Database has many strategies for protecting itself from abuse. Interesting can you explain why you would use
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |