In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...

Over the years, servers have suffered terribly from malicious attacks that users had to take precautions now and then. Because of that, internet users need to determine how to repair a database in an ...

As you can see, traditional database backup and Zetta's DataProtect service featuring ZettaMirror are really 2 totally different ways to do SQL server backup and recovery. If you're ready to try the ...

Q: We use a lot of distributed transactions and we are now investigating database mirroring to provide high availability to one of our critical databases. During our testing, we discovered that ...

Despite the plentiful information in Books Online and on the official “SQL Server 2000 Security” document Microsoft offers online, setting up a truly secure SQL Server remains a difficult task. In ...

So, I can make a LAMP stack dance, but I have no MS experience whatsoever, and now I'm taking on some work involving an ASP.NET/IIS/SQL Server setup, and I feel like I'm in a foreign country.<br><br>I ...