Forum Replies Created

Viewing 15 posts - 2,941 through 2,955 (of 9,241 total)

  • RE: Availalbility Group Error

    😉

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

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

    September 23, 2014 at 4:07 am

    #1747353

  • RE: Database Encryption in SQL Server 2012

    jacksonandrew321 (9/23/2014)

    Check the permission on the path to ensure the database engine can write there.

    How can I check the permission for the same.

    You'll need to check the NTFS permissions...

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

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

    September 23, 2014 at 4:06 am

    #1747352

  • RE: No disks were found on which to perform cluster va??

    You have or havent solved it, what did you do to solve it??

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

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

    September 23, 2014 at 1:07 am

    #1747301

  • RE: Database Encryption in SQL Server 2012

    jacksonandrew321 (9/23/2014)

    Hi I follow each and every steps and final output is given below:

    USE SQLEmployees

    GO

    BACKUP CERTIFICATE [MyServer_Cert] TO

    FILE = 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\MyNewCert.cer'

    WITH PRIVATE KEY(

    --DECRYPTION BY PASSWORD = 'encryption',

    FILE =...

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

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

    September 23, 2014 at 1:05 am

    #1747300

  • RE: Copy a database between servers with one command

    It's good, quite long though, but then you are working at Cmd prompt level. Powershell would be my preference, you can invoke sql cmds just as easily via PS.

    If i'm...

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

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

    September 23, 2014 at 12:33 am

    #1747296

  • RE: Physical Server move to VM

    Introduce a VM into the existing cluster, this will allow you to retain the physical servers into the config. Once you're happy remove the physical boxes from the cluster

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

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

    September 22, 2014 at 3:22 pm

    #1747251

  • RE: use sp_msforeachdb and sp_msforeachtable and sp_spaceused together

    aires (9/22/2014)

    hello

    I wonder if anyone has used these three procedures together?

    sp_msforeachdb and sp_msforeachtable and sp_spaceused

    EXEC sp_MSForEachDB

    @command1 = 'EXEC sp_MSforeachtable [?];',

    @command2 = 'EXEC sp_spaceused [?]'

    Go

    I have about...

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

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

    September 22, 2014 at 10:03 am

    #1747164

  • RE: Availalbility Group Error

    Ratheesh.K.Nair (9/22/2014)

    Hi Experts,

    We are getting below error in our secondary replica.

    The mirror database, "Financials", has insufficient transaction log data to preserve the log backup chain of the principal database. ...

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

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

    September 22, 2014 at 7:16 am

    #1747063

  • RE: No disks were found on which to perform cluster va??

    isnt this the same as this one 😉

    http://www.sqlservercentral.com/Forums/Topic1611752-2799-1.aspx

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

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

    September 22, 2014 at 7:13 am

    #1747062

  • RE: Database Encryption in SQL Server 2012

    jacksonandrew321 (9/22/2014)

    Hi Folks,

    How can I create encryption on database ?. When I try to apply encryption on my database then it showing error message below:

    Can you provide more detail on...

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

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

    September 22, 2014 at 7:11 am

    #1747061

  • RE: Altering the DB Role?

    So the login "restricted" owns the database "maintain", is this the login you wish to change database access for?

    Under sql server 2012, to add a database principal to a role...

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

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

    September 22, 2014 at 12:34 am

    #1746938

  • RE: Altering the DB Role?

    Chowdary's (9/19/2014)

    Thank you for your Reply @Gail,

    I am trying to remove the db_owner role to that Login but it is showing an error like

    "Cannot Use the Special Principal 'dbo'...

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

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

    September 19, 2014 at 7:40 am

    #1746716

  • RE: Cluster query

    zedtec (9/19/2014)

    Hi,

    I just wanted to know, at what stage of the windows cluster setup are Quorum and MSDTC created?

    Is it when creating the failover cluster within Server Manager when these...

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

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

    September 19, 2014 at 6:03 am

    #1746682

  • RE: Server Group Policy Denies access

    you'll need to speak to your domain admin as they will push AD policies and permission to filter or remove them.

    Why are you trying to grant the user RDP access...

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

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

    September 19, 2014 at 5:55 am

    #1746680

  • RE: Cluster validation

    Scorz (9/18/2014)

    Perry Whittle (9/18/2014)

    How many network cards are installed\configured on each node?

    4 NIC on each, teamed

    Check the NIC teaming to ensure all NICs are teamed correctly

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

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

    September 19, 2014 at 5:16 am

    #1746674

Viewing 15 posts - 2,941 through 2,955 (of 9,241 total)