Forum Replies Created

Viewing 15 posts - 2,071 through 2,085 (of 7,164 total)

  • RE: stop/start SQL services

    For stopping ad=nd starting a serving SQL Server Configuration Manager MMC, Windows Services MMC, WMI, PowerShell -Services cmdlets...all of those will work fine. If you're configuring services though, e.g. changing...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 9, 2013 at 6:24 am

    #1586219

  • RE: Dialogue box from SSIS's script task throw error when called through SSMS Job

    I just learned about the possibility in a book I am reading and thought I would pass it along either for you or future readers looking for a way to...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 8, 2013 at 4:29 pm

    #1586177

  • RE: Transaction Log Backup

    midnight251 (2/8/2013)

    Our company has never backed up the transaction log file, and is now about 143 gig, with about 35 gig left on the drive, and I have to get...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 8, 2013 at 1:51 pm

    #1586137

  • RE: Data and log files with UNC path

    PiMané (2/8/2013)

    It's an EqualLogic SAN 🙂

    So, in theory, it doesn't really matter if its 4 RAID 10 or just the one big RAID 50 with the 24 disks since the...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 8, 2013 at 10:22 am

    #1586066

  • RE: Data and log files with UNC path

    PiMané (2/8/2013)

    opc.three (2/8/2013)

    PS Don't forget to let us know if you get a speed increase from moving to a local path 😉

    Sure, but the implementation will only occur in a...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 8, 2013 at 8:51 am

    #1586006

  • RE: Data and log files with UNC path

    PS Don't forget to let us know if you get a speed increase from moving to a local path 😉

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 8, 2013 at 7:09 am

    #1585948

  • RE: Data and log files with UNC path

    PiMané (2/8/2013)

    This is a 2008 Standard Edition...

    But I'll create a template to change the path to E:

    Thanks,

    Pedro

    I know we're in a 2008 forum. I was just saying that "at least...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 8, 2013 at 7:08 am

    #1585946

  • RE: Database usage details (#reads & write times over a period)

    faisalfarouqi (2/8/2013)

    I want page reads as well as io reads & writes i.e (logical & physical reads/writes). We actually show these results to our sysadmin guys, as they want usage...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 8, 2013 at 7:01 am

    #1585941

  • RE: SQL patches

    Here is a very useful site.

    http://sqlserverbuilds.blogspot.com/%5B/url%5D

    I have run into instances where the build was not listed and it was traced back to a hotfix attained directly from Microsoft for a...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 8, 2013 at 6:55 am

    #1585936

  • RE: Data and log files with UNC path

    PiMané (2/8/2013)

    Disc E: is a logic local drive...

    the command returns

    C:E:Doesn't windows "know" the \\sqlsrv01\Data is a local mapping (E:\MSSQL\Data..)?

    I am not sure how it would. I would not take...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 8, 2013 at 6:51 am

    #1585932

  • RE: cdosysmail works for a few days then stops

    The fact that it works for a while and then starts having trouble is the odd part. Everything I am seeing online talks about it never working at all when...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 8, 2013 at 6:39 am

    #1585924

  • RE: cdosysmail works for a few days then stops

    No problem Grasshopper 🙂 Database Mail is available on SQL 2005 but there is a limitation when it comes to setting the from or reply to addresses dynamically. If that...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 7, 2013 at 9:51 pm

    #1585753

  • RE: cdosysmail works for a few days then stops

    If you're on SQL 2008 implement Database Mail.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 7, 2013 at 8:53 pm

    #1585739

  • RE: Data and log files with UNC path

    PiMané (2/7/2013)

    1. It's a mounted logical drive over a physical RAID50 system disk, The \\ is a shared folder on the drive and most databases are "mounted" via UNC and...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 7, 2013 at 3:53 pm

    #1585686

  • RE: Data and log files with UNC path

    PiMané (2/7/2013)

    1. does the UNC mapping has some overhead since it access via network adapter or is windows smart enough to know the UNC is a local path and uses...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 7, 2013 at 3:14 pm

    #1585679

Viewing 15 posts - 2,071 through 2,085 (of 7,164 total)