Forum Replies Created

Viewing 15 posts - 4,291 through 4,305 (of 9,253 total)

  • RE: Configuration sql 2008 cluster on san storage

    Can you supply more info about how the storage is mapped, it seems to be mapped as one large disk group. The group doesn't contain a disk small enough for...

  • RE: Configuration sql 2008 cluster on san storage

    what do you see under "Available storage" in the Failover Cluster manager snap in?

  • RE: Cluster Installation Time Out Issue

    EdVassie (2/18/2013)


    the best thing is to open a Support Case with Microsoft.

    or hire a consultant to troubleshoot the system for you, which would likely be a lot cheaper than calling...

  • RE: Log Shipping Issue

    Can you post a screenshot of what you see?

    To check the settings for a log shipped database use the following

    against the primary

    exec sp_help_log_shipping_primary_database 'primarydb'

    against the secondary

    exec sp_help_log_shipping_secondary_database 'secondarydb'

  • RE: SQL Server 2008 cluster upgrade

    What operating system is the cluster using Windows 2003 or Windows 2008?

  • RE: Moving Database Files in SQL Server

    you need to move the folder contents under the folder path that contains the file stream data. Check books online for more info on the alter database command

  • RE: Log shipping between SQL Server 2000 and SQL 2008R2

    why do you want to log ship between 2000 and 2008, do you understand the ramifications of doing this?

  • RE: Log shipping between SQL Server 2000 and SQL 2008R2

    Simha24 (2/15/2013)


    I am going to implement log shipping between 2000 (primary ) and 2008 R2 (secondary).

    Why???

  • RE: Log Shipping Failover Test

    MissTippsInOz (2/14/2013)


    However I did, and still believe its necessary

    The idea is to keep the 2 way configuration in place as the document states.

    From the error it sounds like an agent...

  • RE: Log Shipping Failover Test

    The link I posted does not tell you to run sp_delete_log_shipping_primary_secondary or sp_delete_log_shipping_primary_database for the role reversal!!

  • RE: Split VLDB into Multiple data files

    balasach82 (2/14/2013)


    My database is already populate, its 523gb now.

    1. Can I create new files in new drive but in Primary filegroup

    If the database and its primary filegroup is already at...

  • RE: create database failed

    sumith1andonly1 (2/13/2013)


    I try to create database in sql server(logon as windows authentication).

    GOT ERROR : "User does not have permission to create database".

    Then i tried to enable 'sa' account.but it also...

  • RE: Log Shipping Failover Test

    MissTippsInOz (2/13/2013)


    Hi

    I'm currently running some DR testing and have failed over a couple of databases to our DR site. Generally the process was:

    Tail log backup on ServerA with NORECOVERY

    RESTORE...

  • RE: Moving Database Files in SQL Server

    No but since the database id may change history would be lost here

  • RE: Moving Database Files in SQL Server

    Jason Shadonix (2/13/2013)


    Right...but the mere fact that you have to type in slightly different syntax to attach a database isn't by itself an argument to stop detatching and attaching databases....

Viewing 15 posts - 4,291 through 4,305 (of 9,253 total)