Skip to main content
Database Administrators

Return to Question

Copy edited (e.g. ref. <https://en.wikipedia.org/wiki/Microsoft_SQL_Server>, <https://en.wiktionary.org/wiki/log_in#Verb>, <https://en.wikipedia.org/wiki/Notepad_%28software%29>, <https://en.wikipedia.org/wiki/Live_CD>, and <https://www.youtube.com/watch?v=1Dax90QyXgI&t=9m14s>).
Source Link
edit approved Jan 10, 2021 at 18:35
Peter Mortensen
edit approved Jan 10, 2021 at 18:35
Peter Mortensen
  • 349
  • 2
  • 10

Is it possible to edit data inside an unencrypted MSSQLSQL Server backup file (*.bak) without SSMS?

I have found out that, there is a difference error (Remaining Qty <> (Purchase - Sales)) in one of the items in my database. There are more than 5000 items and more than 100,000 transactions has happened up to now. Same procedure runs every time for this calculation. 

But only a single item has aan error and it has happened only 1one time. itIt does not seemsseem to be happening from the application side since it has ranrun for more than 100,000 times. The database server is not physically protected and does not connectsconnect to internetthe Internet. Only my selfI can loginlog in to the server. No exceptions has happened in the procedure since I log the errors. I do not understand how the above error happened.

I have seen that, it's possible to open unencrypted MSSQL serverSQL Server backup files using note padNotepad and read its data. Can some one tell me whetherIs the following scenario is possible or not?

  1. Boot the server using a live cdlive CD and copy the database mdf.mdf file
  2. editEdit and change the data of it (ExExample: some numeric values)
  3. Replace the original mdf.mdf file inon the server with a hacked database

If the above scenario is not possible, is there a chance this has happened due to aan error from the SQL serverServer side or through communication error (Notnot from the application code side).

Is it possible to edit data inside unencrypted MSSQL Server backup file (*.bak) without SSMS?

I have found out that, there is a difference error (Remaining Qty <> (Purchase - Sales)) in one of the items in my database. There are more than 5000 items and more than 100,000 transactions has happened up to now. Same procedure runs every time for this calculation. But only a single item has a error and it has happened only 1 time. it does not seems to be happening from the application side since it has ran for more than 100,000 times. The database server is not physically protected and does not connects to internet. Only my self can login to the server. No exceptions has happened in the procedure since I log the errors. I do not understand how the above error happened.

I have seen that, it's possible to open unencrypted MSSQL server backup files using note pad and read its data. Can some one tell me whether following scenario is possible or not?

  1. Boot the server using a live cd and copy the database mdf file
  2. edit and change the data of it (Ex: some numeric values)
  3. Replace the original mdf file in the server with hacked database

If the above scenario is not possible, is there a chance this has happened due to a error from SQL server side or through communication error (Not from application code side)

Is it possible to edit data inside an unencrypted SQL Server backup file (*.bak) without SSMS?

I have found out that there is a difference error (Remaining Qty <> (Purchase - Sales)) in one of the items in my database. There are more than 5000 items and more than 100,000 transactions has happened up to now. Same procedure runs every time for this calculation. 

But only a single item has an error and it has happened only one time. It does not seem to be happening from the application side since it has run for more than 100,000 times. The database server is not physically protected and does not connect to the Internet. Only I can log in to the server. No exceptions has happened in the procedure since I log the errors. I do not understand how the above error happened.

I have seen that it's possible to open unencrypted SQL Server backup files using Notepad and read its data. Is the following scenario possible or not?

  1. Boot the server using a live CD and copy the database .mdf file
  2. Edit and change the data of it (Example: some numeric values)
  3. Replace the original .mdf file on the server with a hacked database

If the above scenario is not possible, is there a chance this has happened due to an error from the SQL Server side or through communication error (not from the application code side).

Became Hot Network Question
Source Link
lakshitha dilhan
lakshitha dilhan
  • 39
  • 5

Is it possible to edit data inside unencrypted MSSQL Server backup file (*.bak) without SSMS?

I have found out that, there is a difference error (Remaining Qty <> (Purchase - Sales)) in one of the items in my database. There are more than 5000 items and more than 100,000 transactions has happened up to now. Same procedure runs every time for this calculation. But only a single item has a error and it has happened only 1 time. it does not seems to be happening from the application side since it has ran for more than 100,000 times. The database server is not physically protected and does not connects to internet. Only my self can login to the server. No exceptions has happened in the procedure since I log the errors. I do not understand how the above error happened.

I have seen that, it's possible to open unencrypted MSSQL server backup files using note pad and read its data. Can some one tell me whether following scenario is possible or not?

  1. Boot the server using a live cd and copy the database mdf file
  2. edit and change the data of it (Ex: some numeric values)
  3. Replace the original mdf file in the server with hacked database

If the above scenario is not possible, is there a chance this has happened due to a error from SQL server side or through communication error (Not from application code side)