Viewing 15 posts - 6,466 through 6,480 (of 9,241 total)
laddu4700 (10/7/2011)
One of our dev database is in suspect mode, not sure what went wrong.
Below are the details
DBCC CHECKDB (My1C_DevMS) WITH NO_INFOMSGS, ALL_ERRORMSGS
Msg 926, Level 14, State 1, Line...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 8, 2011 at 7:15 am
yassermat (10/8/2011)
I am going to describe my requirement first:
I have a central SQL server which must be synched to other SQL clients. I need a mechanism to synchronize every database...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 8, 2011 at 7:09 am
Well done Mohammed.
This is article is designed to do exactly what has happened here. You've a deal more now haven't you 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 7, 2011 at 1:25 pm
You're only showing 1 hard disk attached to the vm, might be worth deleting the virtual machine and starting again.
What subnet do you have configured for VMNet2?
Can you ping...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 7, 2011 at 1:37 am
mohammed moinudheen (10/6/2011)
I added the 20 GB disk but my laptop got very slow
On a host machine with low resources this is common, creating the pre allocated disk file will...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 6, 2011 at 12:26 pm
timscronin (10/5/2011)
We have a vendor app which will run a our local and other...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 5, 2011 at 2:38 pm
timscronin (10/5/2011)
It won't let me use the ip of the cluster, do I need another IP
yes, and a further unique IP for each extra clustered instance you install.
See my cluster...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 5, 2011 at 2:31 pm
the documentation is clear, witness is designed for high safety. When the witness is set quorum is required, loss of quorum causes the principal database to go offline.
High performance, although...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 5, 2011 at 2:28 pm
with SQL Server 2000 pretty much the only way to move a file was to detach. With SQL Server 2005 and later the ALTER DATABASE MODIFY FILE solution is in...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 5, 2011 at 8:56 am
ok, just remember to monitor the log size and periodically check DBCC LOGINFO() to see the status of the VLFs
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 5, 2011 at 6:47 am
ruan.keyser (10/5/2011)
650mb? :pinch:The script only returned 2 rows
so you shrank the log to the smallest available size. Bear in mind this may grow again so you may want to take...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 5, 2011 at 6:34 am
ruan.keyser (10/5/2011)
How would I know if the mirror is in any way behind the principal?
by the mirroring status synchronised or synchronising, disconnected, etc
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 5, 2011 at 6:27 am
ruan.keyser (10/5/2011)
It now returns 451 rows as to 817 earlier.This should probably be decreasing the more t-log backups are made?
no, this decreases with the shrinking of the log, what size...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 5, 2011 at 6:25 am
so what does DBCC LOGINFO() show now
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 5, 2011 at 5:10 am
ruan.keyser (10/5/2011)
But unfortunately simple recovery won't be possible as the database is mirrored.
OK, in that case you absolutely must backup the transaction log as frequently as is required to avoid...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 5, 2011 at 4:28 am
Viewing 15 posts - 6,466 through 6,480 (of 9,241 total)