February 20, 2009 at 1:29 pm
Hello to all,
Is data files get currupted if client applications switch off the PC or network connection is broken ?
I have used MS Access for my old applications and in above mentioned situation, it got currupted.
I want to know that how SQL server is stable with respect to data files.
For new application I am planing to use SQL Server Express.
Thanks
February 20, 2009 at 1:41 pm
angel0in (2/20/2009)
Is data files get currupted if client applications switch off the PC or network connection is broken ?
No.
Corruption in SQL is mostly cause by problems with the IO subsystems.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 20, 2009 at 1:49 pm
See http://www.sqlskills.com/BLOGS/PAUL/post/Search-Engine-QA-26-Myths-around-causing-corruption.aspx
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
February 20, 2009 at 2:14 pm
thank u GilaMonster and Paul
means no data curruptions if user switch of the computer
when application is running (without Exiting from client application and without doing windows shut down)
Paul's blog is good and informative.
thanks
February 20, 2009 at 3:12 pm
Access gets corrupt because it's in memory on the client machine. Remember that SQL is a server app. It's running on the server, not the client PC adn it won't even notice if the client PC is rebooted.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 20, 2009 at 3:27 pm
Yes, but he said that the server was Express - which most likely will be running on the client PC, hosting a local database. Even so, if the PC gets turned off, the database should recover correctly and corruption should not be the case.
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
February 20, 2009 at 10:13 pm
Thanks GilaMonster, Paul Randal
I came to now the actual reason
-(by Paul)
Yes, but he said that the server was Express - which most likely will be running on the client PC, hosting a local database.
I am planing to use SQL Server Express on one machine and use it from 5-6 machines on LAN. In that case is also stable according to GilaMonster
February 21, 2009 at 3:01 am
angel0in (2/20/2009)
I am planing to use SQL Server Express on one machine and use it from 5-6 machines on LAN. In that case is also stable according to GilaMonster
That's not the only reason. It would be fine even if SQL were on the client machine.
Access requires that the DB be cleanly shut down to avoid problems. SQL has lots of logic and features to ensure that the DB remains consistent even if there is a hard shut down.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 21, 2009 at 6:35 am
Thanks GilaMonster,
for your clerification.
🙂
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply