How do I corrupt a SQL CE Database?

Posted by Peter Tate on Stack Overflow See other posts from Stack Overflow or by Peter Tate
Published on 2010-04-28T20:26:50Z Indexed on 2010/05/23 3:10 UTC
Read the original article Hit count: 423

Filed under:

sql-server-ce

|

Corruption

I want to be able to check for a corrupted database at startup, and then repair it programmatically. I can do that easily enough.

My problem is that I want to test that things work the way I expect. Does anyone know of a way to purposefully corrupt a database so I can test my code?

© Stack Overflow or respective owner

Related posts about sql-server-ce

How programically check if SqlServerCe is installer (System.data.sqlserverce exist)

as seen on Stack Overflow - Search for 'Stack Overflow'
How programically check if SqlServerCe is installer (System.data.sqlserverce exist) in c# .Net 3.5. Can I get the version on SqlServerCe? >>> More
How programically check if SQL Server CE is installer (System.data.sqlserverce exist)

as seen on Stack Overflow - Search for 'Stack Overflow'
How can I programmatically check whether SQL Server CE is installed (System.data.sqlserverce exist) in C# .Net 3.5. Can I get the version on SQL Server CE? >>> More
Slow Update/insert into SQL Server CE using LinqToDatasets

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a mobile app that is using LinqToDatasets to update/insert into a SQL Server CE 3.5 File. My Code looks like this: // All the MyClass Updates MyTableAdapter myTableAdapter = new MyTableAdapter(); foreach (MyClassToInsert myClass in updates.MyClassChanges) { // Update the row if it is… >>> More
SQL Server CE, Visual Studio 2008/2010 RC, and Linq-to-Sql

as seen on Stack Overflow - Search for 'Stack Overflow'
I added an .sdf to my project, added a table, added a Linq-to-Sql dmbl, and tried to add the table to the dbml. The result was an error: "The selected object(s) are an unsupported data provider" This happens in both VS 2008 Professional SP1 and 2010 RC Ultimate. I found someone talking about… >>> More
SQL Server 2005 Merge Replication to SQL Server CE 3.5

as seen on Server Fault - Search for 'Server Fault'
Hi, In my organization, we have a SQL Server 2005 database server (DBServer). Users of an application will normally be connected to DBServer, but, occasionally, would like to disconnect and continue their work on a laptop using SQL Server Compact Edition 3.5 (SQLCE). Due to this, we have been looking… >>> More

Related posts about Corruption

help! corrupt file recovery

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
My supervisor computer crashed last night, and I'm trying to help him out. He made an R script but when he tried to open it, it was empty. But for some reason the file is 7.9kb so it should not be empty i think... anyway when i tried to open it, Gedit gave this error: "The file you opened has… >>> More
Login screen restarts while entering password

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I am having a problem that only occurred after installing the fglrx proprietary driver through the additional drivers app. The exact same issue is described in this question, however it's closed. Must login twice before entering Unity; first login screen has graphical anomalies When I boot up my… >>> More
Error while installing netbeans

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I tried to install NetBeans 7.2 from a downloaded .sh file, but experienced problems. Here's text from the Terminal, which shows what I did and what happened: hridesh@ubuntu:~$ cd Desktop/ hridesh@ubuntu:~/Desktop$ cd full\ netbeans\ 7.2\ for\ linux\ in\ .sh\ format/ hridesh@ubuntu:~/Desktop/full… >>> More
Delete corrupted folder

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I am trying to delete a folder in my home directory; its name is completely garbled. In Nautilus, the garbled text is followed by 'Invalid Directory.' Deleting it with Nautilus stalls; I can't type in the garbled name in the terminal. peter@io_vbox:~$ ls -lbdR * ... drwxrwxr-x 3 peter peter … >>> More
How do I fix a corrupted harddrive after failed upgrade?

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
The problem originated when I was trying to fix this problem. Things went horribly, horribly wrong and I ended up with a new problem altogether. The last thing I did was run sudo apt-get install and that caused my system to freeze. I restarted my computer and it would not boot from the harddrive… >>> More