Forum Replies Created

Viewing 15 posts - 1,261 through 1,275 (of 9,244 total)

  • RE: Virtual or Physical

    usually the error log will identify virtual machines as the instance starts, look for the hardware info

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

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

  • RE: Moving prod databases from one server to another.

    Bharatvip (5/11/2016)


    We are moving 6 production databases from one physical server to another. The drive numbers and names on the new and old servers do not match up, but we...

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

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

  • RE: 2008 to 2008r2 on active passive cluster

    you can run an inplace upgrade, install passive nodes then failover and complete remaining nodes.

    Clean install and migration would be my preference

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

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

  • RE: Create Dev VM by Cloning Production VM

    why not just use a clean VM and backup and restore the database and the certificate. Having your prod certificate on a dev database server is questionable itself, your IT...

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

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

  • RE: AlwaysOn: The local replica of availability group XXX is going offline because either the lease expired or lease renewal failed. This is an informational message only. No user action is required.

    sounds like you're using DHCP assigned addresses, configure reservations for the addresses

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

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

  • RE: Always On Availability Group - Log Backup on Secondary

    is this the first ever full backup taken for this database?

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

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

  • RE: Always On Availability Group - Log Backup on Secondary

    copy_only does not interfere with log backups, this option prevents the differential base lsn from being incremented and stops an intermediate full backup from breaking the differential backup chain, logs...

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

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

  • RE: Moving System db files in Cluster server

    Arjun SreeVastsva (4/25/2016)


    Hi,

    i am trying to move system files in cluster server my alter database modify file command but i am getting below error message Can any one help me...

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

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

  • RE: Add/ delete tempdb datafile to instance on windows cluster

    ashwan (4/26/2016)


    hi,

    could any one know how to add and remove tempdb datafile to tempdb.

    reason. we need allocate more space for tempdb and remove in few days time.

    how do we...

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

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

  • RE: Disable SQL Login vs deleting an SQL DB User

    Tava (4/25/2016)


    I have a question from a security point of view & everyone seems to have different opinions. so not sure if people understand this exactly.

    I have an SQL Login...

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

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

  • RE: Moving database master key from sql server 2008 to 2014

    Doug Simmons (4/26/2016)


    When I moved my database to an existing sql server 2008, I ran this script on the old server :

    BACKUP MASTER KEY TO FILE = N'path_to_file'

    ENCRYPTION BY PASSWORD...

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

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

  • RE: SQL Server Resource Governor

    nice article on enabling RG

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

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

  • RE: The mystery of transaction logs

    WhiteLotus (4/17/2016)


    Hi guys ,

    I notice my transaction log grew bigger starting from last week . I checked the log backup at that time was not running half day for all...

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

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

  • RE: Timeouts in SQL Server 2008 r2 Clustered Environment

    GonnaCatchIT (4/17/2016)


    Anymore views anyone....

    Is this a cluster on virtual machines?

    Smendle (4/17/2016)


    1. Is the cluster heartbeat on a separate nic/vlan?

    Not really relevant in Windows 2008 R2 clusters, the heartbeat connection...

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

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

  • RE: Error after changing SQL server service account

    SQL!$@w$0ME (4/15/2016)


    Hi guys,

    I get this error after changing sql server service account from LocalSystem to a domain account (SQL 2008).

    "Windows kernel object 'Global\SQL_90_MEMOBJ_MSSQLSERVER_0' already exists. It's not owned by the...

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

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

Viewing 15 posts - 1,261 through 1,275 (of 9,244 total)