Forum Replies Created

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

  • RE: how to install N no of Sql server at a time

    Standalone or clustered instances?

    For standalone you can use precreated INI file configurations and point setup.exe to the INI file.

    The other option is to build sql server into your server image...

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

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

    September 23, 2014 at 5:49 am

    #1747378

  • RE: certificate problem for restoring a database even if no database or backup encryption

    aplogies, my mistake. Even so if it's TDE the link i posted still applies, it details how to backup and restore the cert to a new server, which is the...

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

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

    September 23, 2014 at 5:19 am

    #1747368

  • RE: certificate problem for restoring a database even if no database or backup encryption

    vincent.D_FR (9/3/2014)

    Hello,

    I have a problem that seems to be a bug existing in SQL 2008 R1/R2 http://support.microsoft.com/kb/2300689/en-us ). But I work on SQL 2014, so I don't know what to...

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

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

    September 23, 2014 at 4:12 am

    #1747354

  • 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

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