Forum Replies Created

Viewing 15 posts - 5,821 through 5,835 (of 9,253 total)

  • RE: Detach and Attach error, Help Needed

    Danzz (3/21/2012)


    I had admin access on the server,

    sadly, that does not guarantee you have access to the files, it is possible to remove ACLs for a file so that an...

  • RE: Failover Clustering and DTC

    Calvo's link is fairly detailed, you may also see my article at this link[/url], review the top section for installing the Windows roles and services which include Windows DTC configuration...

  • RE: backup/copy standby/read-only database

    Benki Chendu (3/21/2012)


    But I am trying to restore the database on an entirely different server?

    This doesnt mean the files dont already exist, especially if the database has been restored there...

  • RE: SQL Server mirror pause

    oskargunn (3/21/2012)


    Hello,

    I have a question regarding pausing a mirrored database.

    Let´s say I have DB1 which is mirrored to standby site into DB2.

    I need to move DB2 physically to another place...

  • RE: Detach and Attach error, Help Needed

    Danzz (3/21/2012)


    Hi everybody,

    I was able to Detach the database successfully, When I try to copy .mdf file to different location:

    it gives me an error saying:

    Cannot copy <<fname>>:...

  • RE: Problem patching to 2008 SP3

    Kenneth.Fisher (3/20/2012)


    but as soon as I have one I'll give the un-install of the setup support files a try.

    Thanks

    Kenneth

    Have you tried my suggestion!

  • RE: SQL Cluster - Multi Instance

    hindle.steve (3/20/2012)


    I have a SQL 2008 R2 Cluster name of say SQLCluster1 on NodeA with an instance name of Instance1 ie. SQLCluster1\Instance1. I also want to install another instance called...

  • RE: Can we set up separate network card for Backups and Log shipping?

    The backup drive is a local SAN presented drive

  • RE: Problem patching to 2008 SP3

    Kenneth.Fisher (3/19/2012)


    Perry Whittle (3/19/2012)


    how long have you left it for, what do you see in task manager?

    I've left it for several minutes but didn't notice anything in task manager.

    At this...

  • RE: Can we set up separate network card for Backups and Log shipping?

    gmamata7 (3/19/2012)


    the backup drive is Clustered Shared drive sitting on SAN. So in that case, we do not need any separate NIC as the backup directly writing to disk on...

  • RE: Can't configure log shipping

    To use log shipping in SQL Server 2000 did indeed require Enterprise edition, but that's not the issue here.

    Del Lee (3/19/2012)


    Any more suggestions on this? I am now seeing...

  • RE: Problem patching to 2008 SP3

    how long have you left it for, what do you see in task manager?

  • RE: SQL Architecture Consolidation

    rabensql (3/8/2012)


    Dear all,

    I'm planning implementation of a new SQL infrastructure for my customer in the project department. Currently, I have really few information’s, which will come later from production department....

  • RE: How to rename the physical Nodes servernames in a Cluster?

    DBA in Unit 7 (3/14/2012)


    Thanks a lot for the pointer, Gianluca. That is quite helpful.

    Looks like there is more to it.

    I may reconsider if this is worth to doing...

  • RE: Unable to shrink an almost empty ndf file

    sbaker-757360 (3/19/2012)


    Thank you Perry for the script.

    You're welcome

    sbaker-757360 (3/19/2012)


    But when I recreated the other 5 indexes, I failed to edit to the new filegroup.

    So I have 46.2GB of index...

Viewing 15 posts - 5,821 through 5,835 (of 9,253 total)