Viewing 15 posts - 2,296 through 2,310 (of 9,253 total)
on the 2 servers that are not working as expected please run the following query.
select differential_base_lsn, differential_base_time
from sys.master_files
where database_id = DB_ID('yourdb')
and type = 0
group by differential_base_lsn, differential_base_time
If the result is...
March 5, 2015 at 10:26 am
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...
March 5, 2015 at 7:19 am
have you specified the correct database name, it defaults to the same name as the primary
March 4, 2015 at 8:05 am
what version of the Windows OS are you using for the cluster?
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...
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
March 3, 2015 at 4:05 pm
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
March 3, 2015 at 8:22 am
yes and although its green go read the step history thoroughly 😉
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"
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...
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
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...
March 2, 2015 at 12:24 pm
Viewing 15 posts - 2,296 through 2,310 (of 9,253 total)