Viewing 15 posts - 2,296 through 2,310 (of 9,241 total)
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
You must remove the primary database from any log backup maintenance plans or jobs. The log shipping plan will create a dedicated agent job that will schedule the transaction log...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 2, 2015 at 10:34 am
do you have log backups running on this database
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 2, 2015 at 10:31 am
New Born DBA (3/2/2015)
Restored with recovery
The secondary database must be restored with either NORECOVERY or STANDBY.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 2, 2015 at 9:26 am
Viewing 15 posts - 2,296 through 2,310 (of 9,241 total)