Forum Replies Created

Viewing 15 posts - 4,321 through 4,335 (of 9,253 total)

  • RE: Cluster Installation Time Out Issue

    Check network connectivity between the nodes and the domain.

    Have you checked the windows event logs and also the cluster events for further info.

  • RE: SQL 2012 cluster upgradation

    Have you ever carried out an upgrade of this type before?

    Do you plan to use a side by side upgrade or upgrade the existing system?

    What SQL Server service pack level...

  • RE: Cluster Installation Time Out Issue

    have your server admins check that each node is well connected to the domain for starters.

    Are these physical or virtual machines?

  • RE: Cluster Installation Time Out Issue

    Can you supply a little more detail about the environment and exactly what steps you are at when you get the failure?

  • RE: Moving Database Files in SQL Server

    Willem Gossink (2/11/2013)


    Perhaps I did not explain my point clearly.

    Your article suggests using the "ALTER DATABASE ... " T-SQL command to bring the database back online. This is, of...

  • RE: Moving Database Files in SQL Server

    SQLDBA360 (2/11/2013)


    Nice artical, I must admit i'm still a fan of detatching the databases to move files

    No longer necessary to detach the database. The ALTER DATABASE ... MODIFY FILE command...

  • RE: Moving Database Files in SQL Server

    Willem Gossink (2/11/2013)


    Good article! One possible source of confusion: the screenshots showing 'completed with errors' and 'success' will not show after issuing the command "ALTER DATABASE [yourDB] SET ONLINE" but...

  • RE: Moving Database Files in SQL Server

    Pradeep Hebballi (2/11/2013)


    Hi Perry, the article was really helpful. Thanks!

    Thank you, i'm glad you found it useful\helpful

    Pradeep Hebballi (2/11/2013)


    You mentioned that SP_ATTACH_DB is deprecated. Does that mean that we cannot...

  • RE: Mirroring failover

    Richard Fryar (2/8/2013)


    This script checks all databases in one go, and avoids use of a cursor.

    Have you seen the code for sp_MSForeachdb????

    SQLCrazyCertified (2/8/2013)


    Is it going through each database that I...

  • RE: Mirroring failover

    SQLCrazyCertified (2/8/2013)


    Hi Perry,

    So, basically what it is doing is, it is creating the login using the SID of the user? and mapping it?..

    No, it's not!

    Its finding a database user and...

  • RE: Log Shipping Simple question re: full backup involvement

    sotn (2/8/2013)


    thanks for the all the replies,

    if no activity is performed for 12 hours (overnight) then does not seem make sense to perform 24 tlog backups with no real activity....

  • RE: Log Shipping Simple question re: full backup involvement

    GilaMonster (2/6/2013)


    even then a diff backup's usually easier.

    Providing a full backup hasn't occurred since the LS plan broke otherwise the Differential_Base_LSN is incremented and the Diff will no longer be...

  • RE: Migrate Virtual SQL Cluster to Physical Cluster

    Knut_knut (2/7/2013)


    ESX version (know its 4 or 5 not sure though)

    Important to know, there's big differences and improvements between 4.0, 4.1 and 5.1 😉

    Knut_knut (2/7/2013)


    How the disks are mapped

    You...

  • RE: SQL Log Shipping out of sync - Comparing Log shipping Primary and Secondary Servers

    george sibbald (2/7/2013)


    BTW, you don't need to reconfigure logshipping you can use your existing jobs and set up, just reinitialise the backup.

    You would be best pausing log jobs, taking a...

  • RE: Migrate Virtual SQL Cluster to Physical Cluster

    1 and 3 are essentially the same arent they?

    Knut_knut (2/7/2013)


    2. Install new servers, add them to the cluster, install SQL. Failover to the new nodes, shutdown the old machines.

    This method...

Viewing 15 posts - 4,321 through 4,335 (of 9,253 total)