SQLServerCentral / Idera / Third Party Products / Products and Books

idera sqlsafe trying to acess a share as NT authority/system - failing

mottya — Mon, 04 Mar 2013 14:06:59 GMT

I am trying to restore a .safe file over a network share - and in ssms i get the message Connecting to back service sucessfull then i get a message that access is denied to the file share.The SQLSafe service is running under a domain user that definitely has permissions to connect to the shareI used process monitor to see whats going on - and it seems that its trying to connect to the share as "NT Authority\System" which is a local accountany help please

OS disk time on disk is currently 100.00%

jclare — Thu, 28 Feb 2013 11:59:18 GMT

This error message is from Idera's SQL Diagnostic monitor.I am getting this critical warning on a newly built SQL Server 2008 R2 build. It is reporting this error for all the drives on the disk even the ones with no data on them.I monitor 4 other instances and don't see this. Everything appears OK on the actual server when monitoring locally. I think the tool is reporting this incorrectly. Any ideas or experience would be helpful.Thanks,Jim

SQL Diagnostic Manager

colin.Leversuch-Roberts — Thu, 21 Dec 2006 04:03:00 GMT

As this is a new forum point I'd just like to say how much I like this product, I've used it since the days of it being SQL Probe, 199? , can't remember now.

Restore Log using SQLSafe

Jaime E. Maccou — Tue, 26 Apr 2011 23:21:26 GMT

Hi all,Using the command line for SQL Safe, does anyone have a script for backing up and restore the logs. I find a lot of information based on backups and restore of the database but not restoring logs. Any insight?

SQLSafe Command line with no recovery

Jaime E. Maccou — Mon, 25 Apr 2011 22:18:15 GMT

I am using sqlsafe to restore a large database using the following:DECLARE @ResultCode INTEXEC @ResultCode = [master].[dbo].[xp_ss_restore] @database = 'test1', @filename = 'F:\Backup\test1_Full_201104050430.safe', @withmove = '"test1_Data" "G:\MSSQL\Data\test1_Data.MDF"', @withmove = '"test1_data2" "G:\MSSQL\Data\test1_data2.NDF"', @withmove = '"test1_Log" "H:\MSSQL\log\test1_Log.LDF"', @securitymodel = 'Sql', @sqlusername = 'sa', [b]@Recovery='norecovery', [/b] @encryptedsqlpassword = 'xvvsvrterstasv'IF(@ResultCode != 0) RAISERROR('One or more operations failed to complete.', 16, 1);I will like to use the command line in the same way put found not information on using the @recovery='norecovery' for the command line. Can someone provide some pointers.Here is the command line: "C:\Program Files\Idera\SQLsafe\SQLsafeCmd.exe" Restore test1 F:\Backup\test1_db_dump.safe -Replace -Move test1_data2 G:\Mssql\Data\test1_data2.NDF -Move test1_Log H:\MSSQL\Log\test_Log.LDF -SecurityModel Sql -SqlUsername sa -EncryptedSqlPassword xvvsvrterstasvAny help will be greatly appreciated.

Partitioning of MSSQL 2005 DB

vrijesh prajapati — Mon, 25 May 2009 09:08:10 GMT

Respected allWe have 60 gb database which having 20 gb of one table which we would like to partition & make it a different as separate primary or secondary filegroups to improve the performance.Please suggestvrijesh

how to compare the vaules of counters given by idera

vrijesh prajapati — Sat, 18 Aug 2007 11:09:00 GMT

Respected sir

How do we compare the values given by Idera & with which default configuration.For ex.

If suppose value of one counter like Processor Queue length given by idea is 2

So how do we come to know whether this value is true ? & What do we compare with ?

So please suggeston this.

Vrijesh Prajapati

multiple domains in Idera??

kerobin jesu — Thu, 30 Aug 2007 00:54:00 GMT

HiCan any one help to find whether Idera Sqlsafe will work in different domain...?In my office we have a sqlsafe respository and we have jobs running from diff instances with same domain...Now i'm planning do the same to my other server which is in diff domain... do i have to set up a new repository for that server domain or it will work with my old repository itself..??Thanks in Advance!- Kerobin

My Scheduled SQL 2000 Backup Taking too long

vrijesh prajapati — Sat, 18 Aug 2007 11:19:00 GMT

Respected Sir/s
MY Database size (including MDF, NDF & LDF) is 8 Gb, and the backup size for the same becomes 7 Gb , but when Scheduled backup start, the application goes very very slow down. Any process takes longer time till backup completes. Time for backup to complete is 40-50 minues.

So please suggest on this topic.

Vrijesh Prajapati

Diagnostic Manager VS Teratrax Performance Monitor

Bart Snyder — Mon, 19 Mar 2007 14:13:00 GMT

I tried Diagnostic Manger and like it a lot, but the price it about $900.00 more than Teratrax and they both seem to do the same thing. Does anyone have any real world experience using either? I am trying Teratrax at the moment and it seems pretty good, just not as refined as DM. Any thoughts would be appreciated.
Thanks,
Bart