-
-
Recent Posts
Categories
- Certification (1)
- Cloud Computing (5)
- Community (40)
- Events (61)
- Inside SQLSaturday (1)
- Learning (4)
- Linux (26)
- Networking (8)
- Oracle (5)
- Personal Development (45)
- Public Speaking (1)
- Security (7)
- SharePoint (3)
- SQL (128)
- SQLSaturday (1)
- SQLServerPedia Syndication (160)
- SSIS (2)
- Storage (9)
- Systems Center (1)
- Uncategorized (1)
- Virtualization (14)
- Windows (32)
Tags
24HOP Active Directory AlwaysOn APT Automation Availability Availability Groups Backup and Recovery Blogger Table Business C# Charity Clustering Concurrency Configuration Connectivity Constraints Database DBMS_SCHEDULER Desktop Development Disable DMV DNS dotnet Enable Error Escalation File-System GUI Humour Hyper-V Integrity Isolation Levels Jobs Kalen Delaney Linux Listener Locking Mirroring NETBIOS Nomcom Parallelism PASS Summit Performance Public Speaking Quorum RAC Reporting Rodney Landrum Ruben Pertusa Lopez Scale-Out Scheduling Schema Security Setup SharePoint Saturday Skype Snapshots SQLBits sqlcmd SQL Nexus SQLRally SQLSaturday SSMS Stored Procedure Systems Center T-SQL T-SQL Tuesday TCPIP Tuning Users VirtualBox Wait Stats WINE
Tag Archives: Mirroring
Automating your snapshots
A little while ago I was talking to someone about possibilities of reporting from SQL Server to avoid impacting the production server and the very first thing that sprang to mind was for them to use snapshotting from a mirror. … Continue reading
Posted in SQL, SQLServerPedia Syndication
Tagged Automation, Backup and Recovery, Database, Mirroring, Reporting, Snapshots
5 Comments
Back to front mirror
SQL Server database mirroring was obviously a great feature first introduced in SQL 2005 and will improve even further in the next big release (Denali) but quite surprising to me is how drastically the order in which the transactions are … Continue reading
Posted in SQL, SQLServerPedia Syndication
Tagged Availability, Database, Mirroring
