Forum Replies Created

Viewing 15 posts - 4,021 through 4,035 (of 9,244 total)

  • RE: create linked server using windows authentication

    Mohammed Imran Ali (7/16/2013)


    Thank you for the info on SPNs. I had checked the SPNs are registered under the SQL Server Service account names for both Instance name and the...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Need to restore one file into a database

    Is the table partitioned across multiple filegroups, is this file in its own filegroup?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Shrink database while restoring

    Au contrair mon pere

    All the dev and ore systems I have worked with are built to the same exacting specification.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Shrink database while restoring

    As I said though if you partition the drives in accordance with best practices then compression is not available!

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Shrink database while restoring

    ariely.ronen (7/16/2013)


    In fact what is written is not accurate.

    Yes you can "Shrink SQL Database During Restore" using workaround 🙂 and with out "provide enough disk space (=size of the...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: service pack on cluster

    This link details rolling upgrades on sql server 2008.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Database Mirroring Or Log shipping??

    $w@t (7/16/2013)


    i need to get reports based on given values..if i enter today's date i need to get all data till today..reports can be requested any time

    Up to today or...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Raid 10

    you're welcome

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: how to find log shipped databases in given server

    you're welcome

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: create linked server using windows authentication

    Add the domain user to instA and use impersonation.

    Do you have your SPNs set up correctly otherwise windows authentication will still fail?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: DATABASE BACK UP PROBLEM

    Copy_only is detailed in books online.

    Yes provide the script to the developers

    backup database [yourdb] to disk = 'f:\somepath\yourdb.bak' WITH COPY_ONLY

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Moving storage (SAN hp -> eva) with SQL Mirroring

    saqlainkhan (7/15/2013)


    We have a request come in to have the storage moved form HP--> EVA. The server that is part of this has SQL Mirroring on this.

    What will be...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: DATABASE BACK UP PROBLEM

    Mr. Kapsicum (7/15/2013)


    some Developer takes a full backup of the database in an emergency or any situation,, then in that case,,, the Monday differential backup will be of the Latest...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: SQL Disk Error

    adeel.imtiaz (7/15/2013)


    Please see that

    the shared storage can be seen on both machines when one fail.

    Let me explain to you.

    There are two nodes and 1 san.

    shared storage are configured on...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: How to take backup of Single table and how to restore?

    Vlad-207446 (7/15/2013)


    if you are working with SQL2010

    Do you mean 2008 of 2012?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 15 posts - 4,021 through 4,035 (of 9,244 total)