Stack Exchange Archives - Page 17 of 17 - Andy M Mallon

How to pass SSRS params into a URL

October 10, 2015 Andy 0

Question I have Native SSRS configured on a 2012 instance (11.0.2100). I have two reports with images that act as buttons to toggle between the chart report and the detail report. I want to configure the action URLs to dynamically pass in parameters when switching … [Read More]

Will Transaction Log backup to Nul break Always On Availability Group configuration?

August 31, 2015 Andy 0

Question Imagine we have two nodes participating in SQL 2012 AO. This is a test instance. During one of the index rebuild operation the log was grown up really big (250 GB). We are unable to back it up due to space constraint. What if … [Read More]

Error 3203 restoring SQL Server backup: The data is invalid

April 17, 2015 Andy 0

Question I am trying to restore a .bak file (backup taken on SQL Server 2008 R2, compatibility level 100). I am restoring the backup on SQL Server 2012 edition. I get the below error. Unfortunately the original DB from where the DB was backed up … [Read More]

Restoring a SQL Server 2012 database in high availability

November 12, 2014 Andy 0

Question I have a database which is in always-on high availability mode synchronized with another database on a different instance. How can I restore from a .bak file into the primary database using T-SQL? I’m new to high availability and I’ve been advised that I … [Read More]

SQL Server 2012 always-on backup, full vs copy-only

April 25, 2014 Andy 0

Question I need a quick clarification on copy-only backup vs full backup as it pertains to transaction log numbering and restore if required. I have SQL Server 2012 setup with always on for multiple databases. The availability groups are setup with preferred backup on replica. … [Read More]

some SQL Server MSX targets show as Normal, Blocked

March 27, 2012 Andy 0

Question I’ve centralized my farm’s jobs in MSX, covering about 70 instances of SQL Server. Seemingly randomly, at least once a week, several instances will stop accepting instructions. Within the MSX window Manage Target Servers, instead of all instances showing as Normal, they show as … [Read More]