Forum Replies Created

Viewing 15 posts - 76 through 90 (of 433 total)

  • RE: Sql 2008 Cluster instance uninstall

    It is very simple. First remove passive node and then unistall the primary instance.

    "More Green More Oxygen !! Plant a tree today"

  • RE: Reindexing job vs Transaction log backup

    If this is with only one single database? I think there is some issue with database. Check the SQL Server error log what does that say? Run DBCC CHECKDB on...

    "More Green More Oxygen !! Plant a tree today"

  • RE: What is benchmark of sql server?

    You could have specified the environment detail, what type of IO you are expecting etc this clould have helped us in answering your query.

    "More Green More Oxygen !! Plant a tree today"

  • RE: Restore Database in a Network Drive

    First let me caution you for having data & log file on network drive. As said by Gail Shaw

    this will impact perf as well as data corruption and IO issues....

    "More Green More Oxygen !! Plant a tree today"

  • RE: MSDTC Configuration

    TST1 (4/14/2011)


    Hi,

    I'm doing a sql cluster 2008 install on win2k8. I have 3 disks partitioned for data, backup and dtc. During the installation of DTC, I have noticed...

    "More Green More Oxygen !! Plant a tree today"

  • RE: SQL 2008R2 CLuster won't come online during install

    Yes AD plays a very IMP role in cluster setup. You need to run the valid cluster and until the report given you aclean go you will face issues.

    "More Green More Oxygen !! Plant a tree today"

  • RE: Restore Database in a Network Drive

    Find out if your windows account and SQL Service have access to the network location and if this windows 2008 server then you have to be the owner of the...

    "More Green More Oxygen !! Plant a tree today"

  • RE: Maximum No of Secondary Databases in Log Shipping.

    I think it is unlimited number of secondaries for each primary database.

    "More Green More Oxygen !! Plant a tree today"

  • RE: Logshipping tlogs directly to secondary server (no third-server share?)

    tacy.highland (2/1/2011)


    I'm trying to get some clarification on logshipping...

    I've set up logshipping between primary server and secondary server, with the log files being saved to a shared folder on another...

    "More Green More Oxygen !! Plant a tree today"

  • RE: Shared SQL Server

    There will be a heavy load on SQL Server as all the application will access it. What is the current SQL Server configuration ? What configuration you are planning for...

    "More Green More Oxygen !! Plant a tree today"

  • RE: Trying to connect to a Database

    When you have two instances on the same system one will be the default and other will be the Named instance unless you specifify both to be Named Instance.

    Default instance...

    "More Green More Oxygen !! Plant a tree today"

  • RE: Need to synch up data between LIVE and move to TEST/DEV - but need to preserve schema diffs on TEST/DEV

    Maxer (2/4/2011)


    Is an ETL package in SSIS a better option here?

    I think so, you can map the table columns and pump the data into it.

    "More Green More Oxygen !! Plant a tree today"

  • RE: MSDB

    kalrpuli (9/17/2010)


    which statement true of the MSDB databse

    (1)MSDB is useful in SQLSEVER AGENT

    (2)im MSDB database jobs executed automatically

    (3)both are true

    (4)none of statement true

    This is a professional forum appreciate if the...

    "More Green More Oxygen !! Plant a tree today"

  • RE: back up restore issue

    Please follow the advice as Roy pointed out to zip the backup file while transfering and then try restoring the backup.

    We had similar issue in out Stage server and...

    "More Green More Oxygen !! Plant a tree today"

  • RE: SQL Server Management Studio’s Dropdown box contains server list not exist

    Is that a default instance or named instance, Did you try explicitly typing the instance name and connecting to it.

    Is this a express edition?

    What does the error log say?...

    "More Green More Oxygen !! Plant a tree today"

Viewing 15 posts - 76 through 90 (of 433 total)