Forum Replies Created

Viewing 15 posts - 496 through 510 (of 860 total)

  • RE: database size

    gsuvarnarekha (2/28/2011)


    Hi All,

    Could any one give me T-sql script for finding the database size for all databases which will be...

  • RE: Backup to remote location

    gpitkis (2/23/2011)


    Hello to All,

    I have to backup a db( 3GB in mdf file, 200GB in ldf file, no free space) to remote location.

    Any suggestions?

    Thanks in advance for your help

    3GB in...

  • RE: Cusror Loop to attach databases which are numbered from 1 to 294

    Thanks Lowell its sysaltfiles.

  • RE: Cusror Loop to attach databases which are numbered from 1 to 294

    bsouji2006 (2/25/2011)


    Hi everyone,

    i need to attach databases automatically by cursor loop. my databases are like ac_001 till ac_294.

    if anyone has idea can you please share with me.

    thankyou

    Try to write a...

  • RE: database mail error

    bsouji2006 (2/25/2011)


    hi everyone,

    can anyone please help me

    i have configured database mail, we dont have Mail server(smtp), so i have used gmail. am getting following error

    The mail could not be sent...

  • RE: Available MBytes goal?

    shifty1981 (2/17/2011)


    sean.massey (2/16/2011)


    You may want to check out these DMV queries to help see where you have a bottleneck but with low page life expectency and paging I'd be thinking...

  • RE: Configuring Database Mail

    You have some problem with your smtp server.

    1.check the account & password

    2.Check the mail server smpt & fire wall too

    3.Restart the server and try again

  • RE: Keylookup Simulation

    I think you just copied from your email 🙂

    The reason is the index is not fulfill the where condition.

    select ParentEmployeeKey,SalesTerritoryKey,title from DimEmployee where ParentEmployeeKey = 3 and SalesTerritoryKey = 11

    You...

  • RE: Maintenance plan and jobs keep failing

    Did you see the M.Plan history error?

  • RE: Available MBytes goal?

    kp_kumar (2/15/2011)


    i can see low PagelifeExpectancy and high pages/sec showing memory issue..

    Start a new thread to ask the questions.

  • RE: Configuring Database Mail

    iczerz,

    Can you show me the errors.

    See the gamil account setup. this may be help to you.

  • RE: Available MBytes goal?

    sean.massey (2/15/2011)


    Hi,

    I don't know if there is enough information provided here to give you a definite answer. Is 150MB too low? Well it kind of depends. Are you seeing paging...

  • RE: Log backup failing due to FlushFileBuffers

    janet.gillespie (2/14/2011)


    I have a differential backup that runs fine one day then fails the next or it runs ok for several days then fails. The database part of the backup...

  • RE: Available MBytes goal?

    shifty1981 (2/14/2011)


    Thanks, but I need some sort of article or technical explanation of why it's important to have roughly 20% of memory available.

    shifty1981

    Check the counters,what i have given? You...

  • RE: Rights to Data Folder

    Yep,You should have that permission.Ask you Manager Or N/W to grant the required privilege.

    If you don't have any choice then go for "cmdshell" (security risk).

Viewing 15 posts - 496 through 510 (of 860 total)