Viewing 15 posts - 6,481 through 6,495 (of 9,244 total)
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
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 5, 2011 at 1:13 am
aberndt (10/4/2011)
Yes, the service is running.
Stop the service and then open SSRS configuration manager
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 4, 2011 at 3:23 pm
execute DBCC LOGINFO() against your database to view details of the transaction log(s)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 4, 2011 at 3:22 pm
aberndt (10/4/2011)
This was my first idea (and my preference) but I cannot get past the WMI error...any ideas on that???
is the service still running
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 4, 2011 at 3:01 pm
sqlstar2011 (10/4/2011)
you dont need an extra license if sql db engine and ssas are active on the same node.
that is correct.
sqlstar2011 (10/4/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 4, 2011 at 2:58 pm
run SQL Server Reporting services configuration manager and use this to create new databases
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 4, 2011 at 2:55 pm
Hi Tony
Thank you for the link, it does a much better job of explaining DTC tracing. It seems the settings are relevant after all 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 4, 2011 at 12:17 am
Viewing 15 posts - 6,481 through 6,495 (of 9,244 total)