Forum Replies Created

Viewing 15 posts - 4,726 through 4,740 (of 9,244 total)

  • RE: Questions on clustering

    Admingod (10/23/2012)


    1. In the clustering, I have Node A, Node B and Node C and we have 5 instances on node A. How do I restart 1 instance on Node...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Symantec NetBackups

    Ryan007 (10/22/2012)


    Hi,

    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...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Move logins from one to anothe

    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...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Question re: service pack upgrade installation when encryption enabled for dbs

    if you're sensible you already have backups of the above 😉

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Question re: service pack upgrade installation when encryption enabled for dbs

    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...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Clearing SQL 2005/20008 TempDB

    Jeff Moden (10/22/2012)


    a futile exercise

    we are Borg 😀 😉

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Shrining log file not releasing the unused space

    Run a couple of log backups in succession and then try shrinking again

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Clustering on SQL Standard Edition vs Enterprise Edition

    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...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Clustering on SQL Standard Edition vs Enterprise Edition

    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,...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: dbcc shrinkfile

    DBA328 (10/21/2012)


    one question about EMPTYFILE paramters:

    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...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Multiple sql servers to a single mirror

    No problem

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Multiple sql servers to a single mirror

    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...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Database Mail Error

    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...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: dbcc shrinkfile

    DBA328 (10/19/2012)


    DBCC shirinkfile may not move data to other files. you can virtually move the data from the table to a different filegroup by creating a clustered index and placing...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Transaction Log Shipping and performance

    Ok but which you using for the scenario you posted about?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 15 posts - 4,726 through 4,740 (of 9,244 total)