Forum Replies Created

Viewing 15 posts - 3,871 through 3,885 (of 9,253 total)

  • RE: Restore Syntax

    Welsh Corgi (11/27/2013)

    I atttached the word work with screen shot and tried to open myself but I could not open it?

    How can I embed an image intop my post?

    Thanks.

    I opened...

    November 29, 2013 at 7:08 am

    #1669833

  • RE: I am not able to connect to sql server database engine from my machine to server having different networks.

    AShehzad (11/25/2013)

    If you can ping the server from your machine then probably it will not be a firewall issue.

    Correct, ICMP traffic is the first traffic a firewall usually blocks. If...

    November 29, 2013 at 7:00 am

    #1669830

  • RE: How to split filegroup files to more than physical storage drive

    MohamedDBA (11/24/2013)

    Are I can spread my database filegroup files to more than storage drive , not on the same storage drive , and stay connected logically as if they in...

    November 29, 2013 at 6:56 am

    #1669828

  • RE: Using VMs in a cluster

    NJDave (11/27/2013)

    Hello

    Could someone provide insight on using 2 VMs in a cluster fro SQL Server 2008 R2 (or higher)?

    Today, I have 2 physical boxes in an active passive cluster that...

    November 29, 2013 at 6:32 am

    #1669823

  • RE: Domain Migration - Log Shipping and Mirroring

    pradeep.mohan (11/26/2013)

    Hi,

    Will it affect domain changes in log shipping and mirroring???

    Because currently SQL server services running on xxxx\xxxxx domain account and log shipping and mirroring working properly. We are planning...

    November 29, 2013 at 6:16 am

    #1669820

  • RE: Need to use Kerberos, but it still is using NTLM

    Marcia Q (3/2/2011)

    I am having trouble with my SQL server not using Kerberos. I read Brian Kelly's article on sqlservercentral.com, but I STILL have problems...

    Here's our setup:

    SQL...

    November 20, 2013 at 9:21 am

    #1667848

  • RE: Sql connection with port number

    sqlmunkee (11/19/2013)

    Do you really need the instance name and the port number ?

    No, you dont.

    use either

    server\instancename

    server, portnumber

    November 19, 2013 at 5:21 am

    #1667360

  • RE: Server side trace question

    sunny.tjk (11/18/2013)

    The steps of the job are

    (1)start trace

    (2)run the trace for 2 mins

    (3)stop trace

    ??

    November 19, 2013 at 1:10 am

    #1667314

  • RE: Corrupt Backup File ?

    homebrew01 (11/18/2013)

    My goal is to make best use of the 4 G ram that I have, and address the apparent Linked Server issues I am having.

    As I said before then,...

    November 18, 2013 at 11:52 pm

    #1667307

  • RE: Corrupt Backup File ?

    homebrew01 (11/18/2013)

    boot.ini has /PAE, but not /3gb

    With your current OS and app config putting /PAE into the boot.ini has done little more than force you to reboot the server 😉

    Windows...

    November 18, 2013 at 4:02 pm

    #1667262

  • RE: Corrupt Backup File ?

    homebrew01 (11/18/2013)

    Perhaps tomorrow I will reduce SQL RAM to 2.5 G, and add the -g700 setting, then restart.

    If you dont have AWE enabled correctly and you set the -g700 startup...

    November 18, 2013 at 8:21 am

    #1667157

  • RE: delete certain nodes

    sstacy7 (11/17/2013)

    How do you delete

    Are you referring to cluster nodes?

    November 18, 2013 at 5:25 am

    #1667101

  • RE: Corrupt Backup File ?

    homebrew01 (11/10/2013)

    I rebooted this morning.

    I thought AWE was set correctly. I'll have to read up on it ... forgot the details.

    I just ran:

    sp_configure 'awe enabled', 1

    RECONFIGURE

    You also need to...

    November 18, 2013 at 5:15 am

    #1667098

  • RE: How to make database back to standby mode

    rajeshjaiswalraj (11/15/2013)

    Hi All,

    before my database was in standby i make it online using

    restore database <name> with recovery

    but now again i want to put my database in standby

    can any one...

    November 18, 2013 at 2:54 am

    #1667055

  • RE: An error while copying database

    SQL_Surfer (11/17/2013)

    can't take compressed backup on 2005...what are other options? because other dbs are pretty similar in size.

    install the trial version of Litespeed and use that to compress and move...

    November 18, 2013 at 2:50 am

    #1667053

Viewing 15 posts - 3,871 through 3,885 (of 9,253 total)