Forum Replies Created

Viewing 15 posts - 3,556 through 3,570 (of 9,253 total)

  • RE: Log Shipping- Out of Synch

    MysteryJimbo (2/20/2014)

    george sibbald (2/19/2014)

    you don't have to reconfigure from scratch, you can use the existing logshipping jobs and shares etc, you just need to reinitialise the database with a norecovery...

    February 20, 2014 at 3:30 am

    #1690589

  • RE: Service restart on cluster

    Yuri55 (2/19/2014)

    Thanks for your response but actually my question was quite different, sorry:-)- if I restart sql server service on currently active node #1 will it trigger automatic failover to...

    February 20, 2014 at 2:09 am

    #1690566

  • RE: SQL Server cluster without Windows Failover Cluster

    oskargunn (2/18/2014)

    Ok, so it requires that Windows Failover cluster feature is installed.

    Thanks for the info, and btw awesome Article on AlwaysON 🙂

    If you like that you'll love this[/url], in...

    February 18, 2014 at 11:45 am

    #1690014

  • RE: SQL Server cluster without Windows Failover Cluster

    oskargunn (2/18/2014)

    Hello,

    I´ve been reading that SQL Server 2012 Always On is dependent on having a Windows Failover Cluster setup. Is that correct ?

    Yes, for more information see my guide at...

    February 18, 2014 at 8:00 am

    #1689922

  • RE: DB mirroring questions ..

    Are the servers on separate sites?

    In this scenario you should work to get the principal online as soion as possible, i've never tested but with both witness and principal down...

    February 18, 2014 at 5:42 am

    #1689848

  • RE: Problem logging on to Integration Services

    k.arkenau (2/17/2014)

    Hello,

    I got a problem with a user who needs to log on to the integration services.

    The user ist is "sysadmin" on the SQL Server and I granted him...

    February 17, 2014 at 10:50 am

    #1689614

  • RE: Error when attempting to start Local SQL Server

    lmpotthoff (2/16/2014)

    I'm a newbie taking an online SQL Server 2012 class. I can't move past the first section b/c I can't get my SQL server to start.

    I've opened port...

    February 17, 2014 at 10:38 am

    #1689610

  • RE: Move SQL Server Machine to another Domain

    Welsh Corgi (2/11/2014)

    I was asked what it took to move a SQL Server 2008 R2 to another Domain.

    The article listed below describes the action necessary to do so:

    http://dba.stackexchange.com/questions/37583/moving-sql-server-to-different-domain

    Does anyone have...

    February 17, 2014 at 10:31 am

    #1689606

  • RE: sql services offline

    ramyours2003 (2/13/2014)

    how to bring the sql services in to offline in a cluseter , naviagte procedure to tak to offline/onlnie ?

    via a command prompt on the Windows 2008 cluster node...

    February 14, 2014 at 9:08 am

    #1689116

  • RE: How to automate moving DB to another server

    wodom (2/13/2014)

    For years it has always appeared to me that the fastest/easiest way to migrate is a backup/restore across the network,

    To a certain point, if the database is not required...

    February 14, 2014 at 5:17 am

    #1689034

  • RE: Log shipping issues 2008 R2

    do you have another mlocation where you can test restore the backup files

    February 14, 2014 at 4:12 am

    #1689013

  • RE: Data + log folder structure changes

    Jake Shelton (2/14/2014)

    Hi all,

    We are migrating to a new server, of course we are splitting out log and datafiles, but otherwise, any best practice on folder naming?

    We were thinking of...

    February 14, 2014 at 3:21 am

    #1689006

  • RE: Log shipping issues 2008 R2

    restoring over a network is just as bad, why do you think the copy job moves the files locally to the secondary instance 😉

    Fo you have any other errors, etc...

    February 14, 2014 at 3:19 am

    #1689005

  • RE: Moving Standby/Readonly DB to New server

    If you really want to move the database and put in standby mode using a backup you'll need to perform the following on the source server

    RESTORE DATABASE yourdb WITH RECOVERY[/CODE]

    BACKUP...

    February 14, 2014 at 2:58 am

    #1689003

  • RE: Log shipping issues 2008 R2

    SQLb2t (2/14/2014)

    I dosent work even after specifying restore file path same as backup location.

    means I am picking same backup file

    I think you're misunderstanding what i am asking.

    Log shipping has a...

    February 14, 2014 at 2:34 am

    #1689000

Viewing 15 posts - 3,556 through 3,570 (of 9,253 total)