Viewing 15 posts - 1,816 through 1,830 (of 9,244 total)
SQLSACT (8/13/2015)
Could you perhaps shed some clarity on why I had to follow this procedure to get model restored?
Because you didn't copy the files from a working instance as suggested...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 13, 2015 at 5:08 am
ft55 (8/12/2015)
Hi all,I'm looking at using Cluster Shared Volumes on a new Windows Server 2012/SQL Server 2014 cluster.
They are supported from sql2014 onwards but bear in mind there are...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 13, 2015 at 4:50 am
one reason for this could be an invalid DNS server IP, check your network settings and work with your network\domain admins to resolve this
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 13, 2015 at 4:39 am
muthyala_51 (8/12/2015)
we went through cluster validation tests. Everything was working fine from last 8+ months. We applied WSUS and SQL2014 SP1 on the box prior to failover. That's when we...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 12, 2015 at 9:54 am
the issues you have are common with double hop auth between the reporting server and the database engine. There will likely be an spn of some kind created (theyre auto...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 12, 2015 at 9:53 am
SQLSACT (8/12/2015)
Been practicing DR strategies with a test SQL instance by following the scenarios listed here:
https://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/
> Took a backup of the Model database
> Stopped SQL Server
> Deleted model database...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 12, 2015 at 8:47 am
DuncEduardo (8/12/2015)
I've installed SQL Server on 3 x 2014 servers for a BI solution (VM environment).
Server A is a warehouse from where data is extracted (read), and Server B is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 12, 2015 at 8:37 am
RonKyle (8/12/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 12, 2015 at 8:33 am
you seem to have a fair number of issues here, can you confirm that the cluster validation was clear of errors before you deployed your availability group
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 12, 2015 at 8:28 am
Jeff Moden (8/10/2015)
Thanks, Perry. I'll check it out.
You're welcome Jeff
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 11, 2015 at 9:51 am
database state changes will be logged in the sql server log, try looking there
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 11, 2015 at 8:45 am
MAP is about as useful as a chocolate saucepan.
There are many tools for providing inventory services on sql server. Redgate and Quest are just examples of tool vendors
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 10, 2015 at 7:12 am
snomadj (8/10/2015)
High saftey. High profile System.
Principal @ site 1, server 1.
Witness & mirror @ site 2, server 2.
Not...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 10, 2015 at 7:08 am
please also run a RESTORE HEADERONLY and provide this info so that we may confirm the actual database name the backup references
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 10, 2015 at 6:56 am
have you checked the DNS server is accessible as the message suggests
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 10, 2015 at 6:52 am
Viewing 15 posts - 1,816 through 1,830 (of 9,244 total)