Tag: Quick And Dirty Database Replication
Quick and dirty database replication with MS-SQL
Microsoft SQL and SQL Express both provide a T-SQL (Transact SQL) command-line interpreter that you can use to automate backup and restore processes. It enables you to utilize publisher/publishee configurations for real-time or near real-time replication. Sometimes, though, all you may want to do is run a daily backup of the database on one SQL Server and restore it to a second SQL Server to keep a "warm standby" available. This can be done easily with a pair of simple batch files. Here’s how you do it: (Oct 18, 2010)
More Recent News
Writing technical doc
Writing technical documentation should not be a complicated procedure. Remember, you’re not writing a novel. You want to communicate information and procedures in a clear and concise fashion. Sometimes basic short... (May 15, 2012)
Go Postal on Spam
You get it at the office. You get it at home. Postal spam a.k.a. junk mail. Since the late 1800’s flyers, ad-mail, unsolicited magazines and pamphlets have been cluttering up people’s mailboxes and, now, people’s... (May 09, 2012)
Single installer to deploy
With the advent of 64-bit hardware, Microsoft has released a 64-bit version of Windows to leverage the capabilities of these hardware platforms. The new Version has the advantages of addressing more than 4 GB of... (May 03, 2012)
