Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: deepfreeze for computers with databases

21 Apr 2020   #1
kivi12

Mersin
 
 
deepfreeze for computers with databases

Hello Iím considering Deep freeze for business. I have 8 Microsoft pos embedded 2009 and 2 Microsoft 2008 servers. Even though I donít want configuration changes done, I need databases to change. I was wondering how deep freeze deals with systems with databases. Can you please help me understand how the system Works, thank you very much.
My System SpecsSystem Spec
.
21 Apr 2020   #2
Snick

Win 10 x64, Linux Lite, Win 7 x64, BlackArch, & Kali
 
 

My System SpecsSystem Spec
21 Apr 2020   #3
Alejandro85

Windows 7 Ultimate x64
 
 

Normally in most workspaces, databases aren't on workstations, but on the servers instead, and more often than not they don't include things like DeepFreeze.

DeepFreeze is useful in untrusted terminals that may be easily compromised, like where browsers with careless users runs, but those are terrible locations for databases, which are secured in servers instead. And since the servers have more safe environments than workstations, and since you lose every file on it if you use it, you don't want DeepFreeze there.

So don't worry about databases, keep them away from the users and DeepFreeze what the users will touch directly.
My System SpecsSystem Spec
.

22 Apr 2020   #4
Snick

Win 10 x64, Linux Lite, Win 7 x64, BlackArch, & Kali
 
 

Alejandro85

I agree with your assessment!

My System SpecsSystem Spec
22 Apr 2020   #5
kivi12

Mersin
 
 

Quote   Quote: Originally Posted by Alejandro85 View Post
Normally in most workspaces, databases aren't on workstations, but on the servers instead, and more often than not they don't include things like DeepFreeze.

DeepFreeze is useful in untrusted terminals that may be easily compromised, like where browsers with careless users runs, but those are terrible locations for databases, which are secured in servers instead. And since the servers have more safe environments than workstations, and since you lose every file on it if you use it, you don't want DeepFreeze there.

So don't worry about databases, keep them away from the users and DeepFreeze what the users will touch directly.
I get your point but im struggling with some viruses which corrupt windows files, but does not harm the database on workstation. On the other hand I have seen that deepfreeze has an app for servers, I was thinking of leaving the database in the thawed area.
My System SpecsSystem Spec
22 Apr 2020   #6
Snick

Win 10 x64, Linux Lite, Win 7 x64, BlackArch, & Kali
 
 

Quote   Quote: Originally Posted by kivi12 View Post
I get your point but im struggling with some viruses which corrupt windows files, but does not harm the database on workstation.
What viruses?
Do you have Anti-Virus, Anti-Exploit, and Anti-Ransomware protections installed on workstations?

Why not sandbox applications?
How to Keep Your PC Safe With Sandboxing | PCWorld

My System SpecsSystem Spec
4 Weeks Ago   #7
Alejandro85

Windows 7 Ultimate x64
 
 

Quote   Quote: Originally Posted by kivi12 View Post
im struggling with some viruses which corrupt windows files
In that case the very first thing you MUST do is to reformat all affected computers. Things like DeepFreeze can help to prevent reinfection, but only if you can ensure it wasn't infected in the first place.
Assuming the virus wasn't powerful enough to tamper with the DeepFreeze image.


Quote   Quote: Originally Posted by kivi12 View Post
but does not harm the database on workstation.
You can never ensure that, once a virus entered your system, it can do whatever the user can, so if the user can read and write a database, so can the virus (wheter or not it really does, it depends on what is the exact malware, but you should never rely on this).

However, having a database on a workstation is a terrible mistake, for more than security. For starters, you can't easily share it among users, which impedes teamwork, or need to share from a workstation, which complicates network configuraton.
But most important it prevents proper backups, as the IT staff won't go into each computer to backup what's important there. Also, there is the security issue of the computer becoming compromised, and the user having full access to take the DB with him if he really wants.

Generally speaking, it's often said that the only important thing in the network are the servers, so that's where all the attention should go. Any data on workstations is considered temporary and unimportant, so it's not cared for. That's why databases and important files are ons propertly secured servers.


Quote   Quote: Originally Posted by kivi12 View Post
On the other hand I have seen that deepfreeze has an app for servers, I was thinking of leaving the database in the thawed area.
DeepFreeze is not a good idea for servers (and I can't think why they need a different program at all). Servers aren't public untrusted places, but controled work areas with secured systems in them. There is little need for it, as any change made was made by an administrator or a properly autorized user. Normal backups cover accidental damage or a virus infection.
My System SpecsSystem Spec
.
Reply

Thread Tools




Similar help and support threads
Thread Forum
deepfreeze
Hello I have recently installed deepfreeze, do you think it may interfere with emails? will it delete all new emails how does deepfreeze work?
Software
deepfreeze without antivirus
my new pc i set to deepfreeze it is no problem without antivirus,because my friend told me if your pc running deepfreeze it is ok without antivirus its true?
System Security
Back up databases.
To backup data on a file server is easy, I use grandfather-father-son schema. But I donīt understand how it works on a database server. (SQL) It has a C and a D drive. The OS is on the C drive and the database is on the D drive. Lets say I make a full backup of C and D drives on the sql...
Backup and Restore
DeepFreeze for Windows 7?
is there a deepfreeze for windows 7? my OS: Windows 7 Ultimate x64 if there is, can i have a gud Link? tnxxx
Software
Dreamweaver CS4 Databases ERROR - Was once connected
Iím working with Dreamweaver CS4 and when I got to my databases / mysql connection / test my connection, I get the following errorÖ. HTTP Error Code 500 Internal Server Error. What is going on and how can I fix this? Thanks in advance Scotty13
Software


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 03:46.
Twitter Facebook