Forum Replies Created

Viewing 15 posts - 4,471 through 4,485 (of 9,253 total)

  • RE: how to create a sql login and add to database user which already exists

    It's deprecated but still usable in SQL Server 2008 R2 and it's a one liner. As follows

    USE [real]

    GO

    EXEC sys.sp_change_users_login 'Auto_Fix', 'appp', NULL, 'somepassword'

    GO

    Then just use

    EXEC sp_addsrvrolemember 'appp', 'bulkadmin'

    December 11, 2012 at 5:30 am

    #1567392

  • RE: Problem in Configuring Mirroring

    shohelr2003 (12/11/2012)

    Is there any security issue? Please let me know.

    Yes, hence why you should use certificates!! See more on NTLM and passthrough authentication at this link.

    December 11, 2012 at 4:58 am

    #1567382

  • RE: 2nd Live Copy

    mike 57299 (12/10/2012)

    That is why I want to have a script to restore it each night.

    your script will need to restore and recover the following each night

    • full backup

    • any...

    December 10, 2012 at 11:12 pm

    #1567259

  • RE: Problem in Configuring Mirroring

    see this link for configuring mirroring using certificates.

    December 10, 2012 at 3:01 pm

    #1567185

  • RE: SQL SERVER 2012 CLUSTERING

    vijayjain347 (12/10/2012)

    Sql server 2012(Standard edition) and windows server 2012(Standard edition) will support AlwaysOn High Availability ???

    You will need SQL server 2012 Enterprise edition.

    vijayjain347 (12/10/2012)

    Windows server 2008 R2 (Enterprise Edition) and...

    December 10, 2012 at 2:55 pm

    #1567184

  • RE: How to rename a SQL Server 2005 Failover Clustered instance

    In failover cluster manager, expand the virtual network name resource and the virtual IP resource will be there.

    December 10, 2012 at 2:46 pm

    #1567181

  • RE: 2nd Live Copy

    mike 57299 (12/10/2012)

    Yes, the data in a writable state is a must. That is why mirroring and log shipping won't work.

    Mike

    It wasn't stated hence my question, now that we...

    December 10, 2012 at 11:17 am

    #1567123

  • RE: move db files to another directory

    sqlfriends (12/10/2012)

    Perry Whittle (12/5/2012)

    Stopping sql server is a bit like using a sledge hammer to crack a nut. You only need to take the database offline as follows

    ALTER DATABASE mydb...

    December 10, 2012 at 11:05 am

    #1567119

  • RE: Slow Full backup in SQL SERVER 2008 R2

    local disk or NAS\SAN based disk?

    December 10, 2012 at 8:28 am

    #1567067

  • RE: 2nd Live Copy

    you want the data in a writable state presumably?

    December 10, 2012 at 3:39 am

    #1566958

  • RE: High availability best practice?

    Martin Stephenson (12/6/2012)

    If I set up log shipping, the translogs are applied to the target database, if the source gets a new full backup, doesnt that break the log chain...

    December 7, 2012 at 4:04 am

    #1566542

  • RE: Log Shipping failing when the primary DB is taken offline

    Perry Whittle (12/6/2012)

    and the results of the query i supplied above????

    ?????????????? :Whistling:

    December 6, 2012 at 11:42 pm

    #1566456

  • RE: Not able to connect db user in standby database

    ananda.murugesan (12/6/2012)

    yes..Thanks

    user apperaing in secondary instance database by atuomatically during restore log shipping process..But it won't connect the application due to login is not apperaing under security->Login, Does we...

    December 6, 2012 at 6:21 am

    #1566130

  • RE: Log Shipping failing when the primary DB is taken offline

    GilaMonster (12/6/2012)

    Has the primary been restored from a backup?

    Questions, questions. It's like the Spanish inquisition here lol 😀

    December 6, 2012 at 6:18 am

    #1566128

  • RE: Log Shipping failing when the primary DB is taken offline

    and the results of the query i supplied above????

    December 6, 2012 at 5:10 am

    #1566104

    • Viewing 15 posts - 4,471 through 4,485 (of 9,253 total)