SQL 2008 Log Shipping Restore Fails after working for some time
Jul 1, 2010 · I recently set up log shipping in SQL 2008 SP1 (Primary, Secondary, Monitor all have SP1). For several days the .trn files are copied and restored to my secondary server's …
Best way of handle Log Shipping in Physical Movement of SQL …
Jan 19, 2014 · One of Server 2005 have Log shipping active. What is best way to maintain Log Shipping during this physical movement. I do not want to remove log shipping and re-configure …
log shipping monitor report error - social.msdn.microsoft.com
May 27, 2009 · I have SQL Server 2005 log shipping setup with primary/secondary configuration. I can confirm from the logs that log shipping is working without issue, however, reports …
Transaction Log because it is being used by another process.
Apr 28, 2016 · I am working on a SQL Server 2008 instance where log shipping is configured for one of the databases. The secondary database is configured on the same instance for …
AlwaysON setup with linked server - social.msdn.microsoft.com
Dec 24, 2015 · I am doing the side by side upgrade from SQL Server 2008 R2 Enterprise to SQL Server 2014 Enterprise. Currently, I have log shipping configured between LIVE and Standby …
Azure Site Recovery for HA workloads? - social.msdn.microsoft.com
Sep 28, 2014 · We recommend enabling SQL log shipping or Availability group and orchestrating that with ASR recovery plan. Thanks, Abhishek Agrawal, PM, Azure Site Recovery Proposed …
Scaling SQL Server Horizontally (Clustering)?
Jan 10, 2013 · The important thing is the data is split up, each node has only a portion of the data (which means queries are faster), we can put the data close to the customer (we have multiple …
SSIS DB Log files - social.msdn.microsoft.com
May 16, 2016 · I have a 25 GB (and growing ..) log file belonging to the SSIS catalogs DB. I set my retention period to 14 days but still no decrease in size. The SSIS Server Maintenance Job …
Database transaction log is full due to 'CHECKPOINT'
Aug 7, 2018 · but I am sure., once the transaction is complete and the data has been written to the data file the space that was used in the transaction log file is now re-usable for new …
How to restore SQL Server 2008 R2 databases on SQL Server 2012
Apr 2, 2012 · After long installation process I was finally successful in installing SQL Server 2012. So, my first idea was to try installing out databases and testing our application against it. But …