BANGALORE, INDIA: Your users expect your systems will stay up as much as possible. This would be in the face of unexpected events such as system failures as well as ...

So you decided to set up log shipping in order to establish a failover server, but what's next? Log shipping only takes care of keeping a user database in sync from one server to the other. In the ...

Log Shipping in SQL Server has been around for a while and still provides an easy method for redundancy and load balancing. It uses standard backup and restore technology to ship backups to a standby ...

For our new production environment, we're going to be using SQL 2005 and do log shipping from our main machine to a secondary machine. Part of this environment will include a migration process, which ...

Don't let an error message or two stop you from getting what you need. Here's a quick trick to keep things running. When building an SSIS package, you probably find ...

This week, I again had the opportunity to be on the Virtumania podcast with Rich Brambley, Marc Farley and a special SQL server guest, http://www.brentozar.com/ Brent ...

Help! My SQL Server Log File is too big!!! Your email has been sent Overgrown transactional log files can turn into real problems if they are not handled properly. Today SQL Server consultant Tim ...

Take advantage of the open source library Serilog to log your ASP.NET Core application’s data to SQL Server or another database target. Logging is an essential feature for any application, as it is ...

SQL Server has a long list of roles for server, database, and applications that outline things like permissions, data selection and modification, and disk management. Examine how roles play a part in ...