Viewing 15 posts - 16 through 30 (of 90 total)
All databases are synchronized and everything is apparently working, that's why this is so frustrating.
August 24, 2015 at 11:56 am
Both full and trans log are done on the primary, as far as I understand full backups need to be done on the primary and 'copy-only' backups can be done...
August 24, 2015 at 11:41 am
The dashboard shows all green arrows, all dbs are in synchronized state and no data loss.
July 22, 2015 at 9:52 am
Regardless if I do a full backup and then a transaction log on either the primary or secondary, the transaction log does not release the space.
July 22, 2015 at 9:35 am
https://www.sqlservercentral/Forums/Uploads/Images/1704069-1.png
Thanks for have a look.
July 18, 2015 at 2:24 pm
There are lots of screens on the backup task, I gave a run down of the important settings, nothing else in there. It's a simple full and trans log...
July 18, 2015 at 1:46 pm
Need to shrink it or otherwise the devs get errors when inserting etc.
Backup type: Full / transaction for second plan
Databases(s): All
Backup to disk
Destination: network share
Checkbox enabled for: For availability databases,...
July 18, 2015 at 1:27 pm
Ended up being an SSMS add-in I wasn't aware was installed, the context menu for it wasn't even showing up. Deleted it from 'C:\ProgramData\Microsoft\SQL Server Management Studio\12.0\AddIns’ and no...
July 8, 2015 at 9:48 am
Yes, I had 10g 32-bit and 11g 32-bit and 64-bit but not 10g 64-bit. Linked servers for Oracle 8 are working now.
May 26, 2015 at 1:13 pm
Thanks Joie!
Yes I was missing the 10g 64-bit client as I'm running 2008R2 64-bit. I needed to use an older oracle version I found (10204_vista_w2k8_x64) and then...
May 26, 2015 at 11:51 am
Yes I am able to connect via SQL*Plus with the 10g client and it is the first one in the Path environment variable.
May 25, 2015 at 8:47 am
Server - Oracle8i Enterprise Edition Release 8.1.7.4.0
Client 10g - 10.2.0
May 21, 2015 at 11:47 am
Thanks Joie. My issue is I do have the 10g client installed that should be able to talk to 8 via linked server, not sure what I'm missing though.
May 21, 2015 at 8:18 am
http://msdn.microsoft.com/en-us//library/ms189493.aspx
"EMPTYFILE
Migrates all data from the specified file to other files in the same filegroup. Because the Database Engine no longer allows data to be placed in the empty...
February 27, 2014 at 1:18 pm
This could be a complicated issue so you want to start at the simplest point. Generally with databases if the CPU is 100%+ that means that RAM is being filled...
January 13, 2014 at 3:26 pm
Viewing 15 posts - 16 through 30 (of 90 total)