Viewing 15 posts - 6,481 through 6,495 (of 9,253 total)
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...
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...
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...
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
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...
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
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...
October 5, 2011 at 6:25 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...
October 5, 2011 at 4:28 am
ruan.keyser (10/5/2011)
It returned over 800 rows :ermm:So I guess I need to schedule the transactional log backups to run let's say every 3 hours?
:w00t:
start the log backups running as...
October 5, 2011 at 4:00 am
use this link http://sourceforge.net/projects/freenas/files/FreeNAS-7-Stable/0.7.2.7903/[/url]
and get the file named "FreeNAS-i386-LiveCD-0.7.2.7903.iso".
The file "FreeNAS-amd64-LiveCD-0.7.2.7903.iso" is the 64 bit version.
When you create the VM use the FreeBSD 32 bit OS type for the i386...
October 5, 2011 at 3:53 am
Raymond van Laake (10/5/2011)
I am using the cheaper version of SQL (2008 R2 Web) that doesn't include replication. I need to replicate the databases on the production-server to another SQL...
October 5, 2011 at 3:17 am
Could you post the output from the following query when executed against your database
DBCC LOGINFO()
run a further transaction log backup to cycle the log and then try shrinking again. With...
October 5, 2011 at 3:15 am
At a guess I would say you're using the 64 bit Freenas ISO and this is not compatible with your host. Try installing from the x86 ISO
October 5, 2011 at 1:31 am
SQLRNNR (10/4/2011)
For more info check the links in my sig for Kimberly Tripp.
Hmm, it is a good article, although I don't agree with Kimberleys statement that detaching a database is...
October 5, 2011 at 1:13 am
Viewing 15 posts - 6,481 through 6,495 (of 9,253 total)