SQL Database

Question

Any body tell me how we create a Corrupt database?

Answer 1

http://blogs.msdn.com/b/sqlserverstorageengine/archive/2007/03/22/easy-way-to-create-a-corrupt-database-for-testing.aspx

---

Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

MS SQL optimization: MS SQL Development and Optimization
MS SQL Blog: Large scale of database and data cleansing
MS SQL Consultants: Improves MS SQL Database Performance

Answer 2

You can also download a few "already corrupted" databases from SQLSkills.com site: http://www.sqlskills.com/BLOGS/PAUL/post/Conference-corruption-demo-scripts-and-example-corrupt-databases.aspx

---

Thank you!

My blog: http://aboutsqlserver.com

Answer 3

Hi R.D.B,

The following link tells the detailed information about how to create a Corrupt database, please try to refer to:

How to create a Corrupt database: http://blog.perrywhittle.co.uk/post/2012/04/16/How-To-Create-a-Corrupt-SQL-Server-Database-for-Test-Purposes.aspx.

Regards,

Amy Peng

---

Amy Peng

TechNet Community Support

Answer 4

Try this :-

1) Create Database

2) Take database offline

3) Open MDF file in notepad

4) Delete data & enter some junk data, in MDF opened in notepad

5) Save the file & close

6) Try to bring database online......and you have your own corrupted database.

---

Regards,
Rohit Garg
(My Blog)
This posting is provided with no warranties and confers no rights.
Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread.