Viewing 15 posts - 4,726 through 4,740 (of 9,253 total)
Something along the lines of this should get you started
Select * from sys.indexes
Where index_id = 1
And data_space_id > 1
October 24, 2012 at 11:58 pm
I suspect theres a deeper issue here. You dont want to be using dynamic disks, these are only designed for use when you want to crete a software raid through...
October 24, 2012 at 11:52 pm
mrtrich99 (10/24/2012)
Perry Whittle (10/20/2012)
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...
October 24, 2012 at 10:59 am
The default timeout is set to 10, you will want to test network connectivity though and adjust this before implementing mirroring.
Can provide more detail about your mirroring setup?
October 24, 2012 at 6:52 am
October 23, 2012 at 12:00 pm
Admingod (10/23/2012)
October 23, 2012 at 9:29 am
Ryan007 (10/22/2012)
I am new to netbackup. I need to check if netbackup is backing up the databases successfully. Where to find and how to check this? Please help.
Is there any...
October 23, 2012 at 2:32 am
This will get all logins (Windows and SQL) that are relative to your particular database, it doesn't retrieve the server roles assigned but that's easy, see if you can work...
October 23, 2012 at 2:04 am
if you're sensible you already have backups of the above 😉
October 23, 2012 at 1:40 am
You just need to ensure that you have backups of all certificates (public and private keys) and backups of all the databases too. It might also pay to review the...
October 22, 2012 at 10:28 pm
Jeff Moden (10/22/2012)
a futile exercise
we are Borg 😀 😉
October 22, 2012 at 1:38 pm
Run a couple of log backups in succession and then try shrinking again
October 22, 2012 at 12:12 pm
uncle_boris (10/22/2012)
thanks for the reply -- SQL 2008 -- therefore I was incorrect in suggesting the licensing has changed for this edition of SQL
Licensing did change at 2008 and 2008...
October 22, 2012 at 3:35 am
uncle_boris (10/21/2012)
Is their any difference in clustering -- performance, setup admin etc between having a 2 Node Cluster using SQL 2008 Std edition or SQL 2008 Enterprise edition.
Not as such,...
October 22, 2012 at 12:01 am
DBA328 (10/21/2012)
If i have 4 data files on one filegroup, then i use DBCC SHRINKFILE with emptyfile paramter to empty the first data file, which file...
October 21, 2012 at 11:47 pm
Viewing 15 posts - 4,726 through 4,740 (of 9,253 total)