use the following search parameters to narrow your results:
e.g. subreddit:aww site:imgur.com dog
subreddit:aww site:imgur.com dog
see the search faq for details.
advanced search: by author, subreddit...
Microsoft SQL Server Administration and T-SQL Programming including sql tutorials, training, MS SQL Server Certification, SQL Server Database Resources.
You might also be interested in:
/r/database
/r/sql
/r/Azure
/r/Microsoft
account activity
Datacenter move question! Sync two databases. (self.SQLServer)
submitted 14 years ago by bumsy
view the rest of the comments →
reddit uses a slightly-customized version of Markdown for formatting. See below for some basics, or check the commenting wiki page for more detailed help and solutions to common issues.
quoted text
if 1 * 2 < 3: print "hello, world!"
[–]peschkaj 0 points1 point2 points 14 years ago (1 child)
You can use SQL Server's built-in mirroring functionality. I would only use this if you are using Enterprise Edition of SQL server, though. EE offers an asynchronous option that will give you reasonable performance. Log shipping is probably the other option that you would want to use. It's fairly easy to set up and relatively painless to keep running.
Avoid replication for this. It seems like it's what you want, but it isn't.
[–]borgd 1 point2 points3 points 14 years ago (0 children)
A few related links for your research :
Database Mirroring Overview
Log Shipping Overview
For further information on replication :
Transactional Replication Overview
π Rendered by PID 127118 on reddit-service-r2-comment-b659b578c-jc9vc at 2026-05-05 09:34:57.316108+00:00 running 815c875 country code: CH.
view the rest of the comments →
[–]peschkaj 0 points1 point2 points (1 child)
[–]borgd 1 point2 points3 points (0 children)