Viewing 14 posts - 181 through 194 (of 194 total)
I changed the user and the message is now:
SQL Server Scheduled Job 'Database Integrity Check.Subplan_1' (0x0BDC5ACFD0A9034E868247EEC6ED3CDA) - Status: Failed - Invoked on: 2011-07-14 13:33:39 - Message: The job failed. The...
July 14, 2011 at 7:32 am
On the single database that i had executed the commands.
July 14, 2011 at 7:26 am
I have failed to establish mirroring with one machine in a domain the other in a group(Because of error 1418).Although i was using certificates.When the machines joined the domain...
July 14, 2011 at 5:59 am
I have run updateusage and the checkdb completes successfully,but my job stil cant run job.
Initially was getting this message:
SQL Server Scheduled Job 'Integrity Checks.Subplan_1' (0x3F3A67A8350F2340B4DFD5BF2E7DF56C) - Status: Failed - Invoked...
July 14, 2011 at 5:50 am
Started: 4:30:23 PM
Error: 2011-07-13 16:30:26.19
Code: 0xC002F210
Source: Check Database Integrity Execute SQL Task
Description: Executing the query "DBCC CHECKDB(N'Firstdatabase') WITH NO_INFOMSGS
"...
July 13, 2011 at 8:38 am
You srcipt the logins or use SSIS job for the transfers.
July 13, 2011 at 5:50 am
Always know that there are some commands which will run on the principal database and not the mirror.So remove mirroring change database owner and reconfigure mirroring.
July 13, 2011 at 1:53 am
For me principal and mirroring are synchronized.Mirroring monitor fine at mirror but showing failure to connect at the principal.
July 8, 2011 at 9:11 am
The problem was in the order of the processes.
1.alter database xxxx set partner of
2.restore database xxxx with recovery
3.lastly reconfigure
To live,to love ,to learn and to live a legacy[/quote]
June 24, 2011 at 7:54 am
Follow this link found it helpful. http://www.sqlservercentral.com/scripts/Security/73511/
June 24, 2011 at 7:43 am
We use Vmware have virtuaalised 7 servers ,a 6 in the production environment
June 24, 2011 at 7:40 am
Try follow step by step mirroring.This link might be useful http://msdn.microsoft.com/en-us/library/ms191140.aspx
June 21, 2011 at 6:27 am
Viewing 14 posts - 181 through 194 (of 194 total)