MS SQL Server - Power failure using simple mode transaction Log

Author

Power failure using simple mode transaction Log

juan carlos via SQLMonster.com

2005-07-09, 1:23 pm

Any comments about what happens when we get a power failure using simple mode
transaction Log?

I had 3 Power failure and there has not been any problems with the data.
The auto recuperation informs that 5343 rows where commited and 0 rolled back.

Can I expect this behaviour in the future? (another power failure).

Note that I have a UPS, but I didn't have time to shutdown properly.

David Portas

2005-07-09, 1:23 pm

Run DBCC CHECKDB if you haven't already.

You should configure your UPS to shutdown the server automatically after N
minutes of power failure.

--
David Portas
SQL Server MVP
--

Tibor Karaszi

2005-07-10, 7:23 am

If you have hardware write cache, you need to make sure it is properly backed up, and follows a
certain set of rules. If it does, the database should not go corrupt because of a power failure. If
you don't have hardware write cache, then you probably don't have battery backup and you can see a
torn page. See http://www.microsoft.com/technet/pr...qlIObasics.mspx for
full information.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/

"juan carlos via webservertalk.com" <forum@webservertalk.com> wrote in message
news:51122050ED1E0@w
ebservertalk.com...
> Any comments about what happens when we get a power failure using simple mode
> transaction Log?
>
> I had 3 Power failure and there has not been any problems with the data.
> The auto recuperation informs that 5343 rows where commited and 0 rolled back.
>
>
> Can I expect this behaviour in the future? (another power failure).
>
> Note that I have a UPS, but I didn't have time to shutdown properly.

Sponsored Links