Viewing 15 posts - 4,741 through 4,755 (of 9,253 total)
The way i'm reading it the scenario you have described is possible. You will have 3 principal instances with a principal database on each that use the 4th server as...
October 21, 2012 at 2:53 am
mrtrich99 (10/19/2012)
The server response was: 5.7.1 Unable to relay for testuser@company.com). ).............
...........Any suggestions on what else I can do to troubleshoot the "Unable to Relay" issue?
You're sending an email...
October 20, 2012 at 4:22 am
DBA328 (10/19/2012)
October 20, 2012 at 4:15 am
Ok but which you using for the scenario you posted about?
October 19, 2012 at 3:06 pm
oradbguru (10/19/2012)
Also, there is no native compression available in SS 2005.
You've posted in the SQL Server 2008 forum!!
October 19, 2012 at 2:54 pm
GilaMonster (10/19/2012)
What's wrong with native backup compression? Standard edition?
excellent backup analyser tools, object level recovery and compressed\encrypted backups without relying on TDE are just some of the reasons
October 19, 2012 at 2:41 pm
oradbguru (10/19/2012)
We are currently trialing Idera SQL Safe for compressed backups.
SQL Safe is a good product, this product should offer you fairly decent backup\restore times even on a database that...
October 19, 2012 at 2:39 pm
catchmekiran (10/19/2012)
October 19, 2012 at 1:18 pm
oradbguru (10/19/2012)
From time to time BI will need to add indexes on the secondary database. How would we accomplish that?David
What do you use for backups are they native, native...
October 19, 2012 at 1:17 pm
can you post the results of the following query please
selectd.name
, dm.mirroring_state_desc
, dm.mirroring_role_desc
, dm.mirroring_safety_level_desc
, dm.mirroring_partner_instance
, dm.mirroring_witness_name
, dm.mirroring_state_desc
, dm.mirroring_redo_queue
, dm.mirroring_redo_queue_type
from sys.databases d inner join sys.database_mirroring dm
on d.database_id = dm.database_id
where d.name = 'yourdb'
October 19, 2012 at 1:13 pm
oradbguru (10/19/2012)
October 19, 2012 at 12:59 pm
SQLDBA ARJUN (10/19/2012)
i forgotten sa account password for my server.i dont know how to recover it.
i tried to retrieve using -m in the sql service properties but
adminstartor account is not...
October 19, 2012 at 2:52 am
oradbguru (10/18/2012)
How would that affect our production and BI databases?
It won't, the log backups will run every 10 minutes as scheduled. This would be no different to the current log...
October 19, 2012 at 2:21 am
muthyala_51 (10/18/2012)
Does dbcc shrinkfile (filename, emptyfile) move the data to other file in the same filegroup thru online or the data will be offline during the moving process?
You may still...
October 19, 2012 at 2:14 am
Viewing 15 posts - 4,741 through 4,755 (of 9,253 total)