Forum Replies Created

Viewing 15 posts - 151 through 165 (of 219 total)

  • RE: Backup a Database from a remote server

    Set up a linked server, then

    exec <<linkedserver>>.master.dbo.sp_executesql 'BACKUP DATABASE <<DBName> to disk='\\<<Server>>\e$\<<DBName>.bak''

    Of course, inserting the proper servername and drive/directories.

    /* ----------------------------- */
    Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

    April 9, 2010 at 4:30 pm

    #1149416

  • RE: Mirror vs. Cluster - Which should we do?

    This is where we are confused - Why would anyone do Clustering at all?

    Clustering provides quick failover, usually under one minute. With no changes for DNS (you connect to...

    /* ----------------------------- */
    Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

    April 9, 2010 at 4:26 pm

    #1149414

  • RE: How do I tell if a server is cluster aware?

    RonKin (4/9/2010)

    I do not have a SQL Server Test Cluster. I have no one where I work to assist me.

    I am currently running SQL Server 2005 Enterprise. I...

    /* ----------------------------- */
    Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

    April 9, 2010 at 8:11 am

    #1149131

  • RE: wmi_mssql_transactionpersec is critical

    RamSteve (4/8/2010)

    what happens if we increase the RAM and the processors ?

    will it bring the transactions per sec down

    No, there are n number of transactions that occur in your...

    /* ----------------------------- */
    Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

    April 8, 2010 at 2:59 pm

    #1148668

  • RE: How do I delete the SQL Server Configuration Manager?

    What version of SQL will you be running?

    It's always best to do a clean install of the OS rather than add/remove SQL

    /* ----------------------------- */
    Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

    April 8, 2010 at 11:42 am

    #1148520

  • RE: File System Task working until all of a sudden - access to path denied

    Look at the ACL's on the file

    /* ----------------------------- */
    Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

    April 8, 2010 at 9:30 am

    #1148394

  • RE: Data compression

    The only reasonably accurate way to estimate those numbers is in your test environment. There are many variables in getting a calculation. Are you storing bits, reals, int,...

    /* ----------------------------- */
    Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

    April 8, 2010 at 8:36 am

    #1148331

  • RE: xp_cmdshell what could happend

    Mike Hinds (4/8/2010)

    GregoryF (4/6/2010)

    ... Hopefully, you have ACL's and the SQL Servcie account is (1) a domain acccount, not local service and (2) not a local admin ...

    I usually use...

    /* ----------------------------- */
    Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

    April 8, 2010 at 7:30 am

    #1148262

  • RE: Two job offers..two different companies

    I've taken a six month contract that I finally left for a new job after 2 years. Remember there are certain accounting rules that make it easier to bring...

    /* ----------------------------- */
    Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

    April 7, 2010 at 5:15 pm

    #1147885

  • RE: Have some question

    lmu92 (4/7/2010)

    Steve Jones - Editor (4/7/2010)

    ... But asking how many types of temp tables exist implies....

    Steve, would you consider a worktable as being the third type of a temp table?...

    /* ----------------------------- */
    Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

    April 7, 2010 at 4:58 pm

    #1147871

  • RE: wmi_mssql_transactionpersec is critical

    RamSteve (4/7/2010)

    I can see sudden jumps some times in the transactions per sec exceding to 3000 and some times 800 and what could be the reason for this sudden...

    /* ----------------------------- */
    Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

    April 7, 2010 at 4:54 pm

    #1147866

  • RE: Changing the URL, or blocking external users

    Stop the service, when you need it start it up.

    Take the reporting DB's off-line, when you need them bring them back.

    Redirect in IIS to the current server (put up a...

    /* ----------------------------- */
    Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

    April 7, 2010 at 1:49 pm

    #1147732

  • RE: how database gets updated on the secondary instance if I have Active/PAssive clustering setup.

    pankaj.baluni (4/7/2010)

    CirquedeSQLeil (4/6/2010)

    pankaj.baluni (4/6/2010)

    AT the time of DR, Storage team will bring up the LUNs for me at the DR Site and I'll turn the SQL servers on. Now as...

    /* ----------------------------- */
    Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

    April 7, 2010 at 8:10 am

    #1147355

  • RE: Have some question

    Alvin Ramard (4/7/2010)

    Assignment questions again?????

    Apparently it's too difficult query google for the answers

    /* ----------------------------- */
    Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

    April 7, 2010 at 7:40 am

    #1147328

  • RE: SQL Servername

    Are you looking for the FQDN Server Name (like ATLSQLPROD01.MyOrginization.Net)?

    /* ----------------------------- */
    Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

    April 7, 2010 at 7:26 am

    #1147311

Viewing 15 posts - 151 through 165 (of 219 total)