Viewing 15 posts - 2,296 through 2,310 (of 9,244 total)
S_Kumar_S (3/4/2015)
I have an application server APP1 in Domain DOMCORP. Then there is another SQL Server machine in DOMCORP domain. The SQL Service is running with Local system account.
When...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 5, 2015 at 7:19 am
what is RO?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 4, 2015 at 9:27 am
have you specified the correct database name, it defaults to the same name as the primary
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 4, 2015 at 8:05 am
what version of the Windows OS are you using for the cluster?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 4, 2015 at 7:47 am
jitendra.padhiyar (3/4/2015)
We have 5 instances on our clients old machine with SQL 2005, now they want us to move on cluster environment with SQL 2012.
Once I have installed and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 4, 2015 at 5:47 am
copy across any remaining logs if possible, then restore them in sequence. The last restore should be with recovery
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 3, 2015 at 4:05 pm
any luck?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 3, 2015 at 10:22 am
WHERE
r.dbAddDate >= DATEPART(dd,'2014-01-01'),
(DATEPART(mm,(CAST('2015 February' AS DATETIME)),
(DATEPART(dd,'2014-01-01')))))
you've missed out a closing ) as indicated above
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 3, 2015 at 8:22 am
yes and although its green go read the step history thoroughly 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 3, 2015 at 8:05 am
even though the restore job is successful, check the step outputs, you'll likely see errors there saying "log file skipped blah blah blah"
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 3, 2015 at 8:01 am
Bouke Bruinsma (3/3/2015)
One of our customers asked us why if having multiple datafiles for tempdb is beneficial
can be beneficial, in most cases you may not even need it, the key...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 3, 2015 at 6:03 am
what is the error, its most likely filesystem permissions error. Check the job step history and post details back
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 2, 2015 at 3:38 pm
on the secondary instance expand the Always Availability section. Expand Availability databases and you should see a little pause symbol on the database rather than a green arrow. Right click...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 2, 2015 at 12:24 pm
yes it can
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 2, 2015 at 11:09 am
cpathidba (3/2/2015)
if you want more services like agent services,db mail services etc. then you need model and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 2, 2015 at 11:08 am
Viewing 15 posts - 2,296 through 2,310 (of 9,244 total)