Forum Replies Created

Viewing 15 posts - 61 through 75 (of 644 total)

  • RE: Automating Database Restores

    ggoble (4/23/2014)

    How does this script handle multiple files and filegroups?

    Edit: Does this script handle multiple file and file groups?

    Yes. It handles multiple file & filegroups.

    Here is an example for you...

    April 24, 2014 at 3:56 am

    #1708355

  • RE: Automating Database Restores

    JoseM (4/22/2014)

    Good script !!! :w00t::w00t:

    The only thing I miss is a parameter to change the destination database name.

    In our case many customer has a mirrored database in the same...

    April 22, 2014 at 5:46 am

    #1707703

  • RE: Automating Database Restores

    Kurt W. Zimmerman (4/21/2014)

    I have found that an automated means of restoring a database vs. using various forms of database replication such as log shipping or database mirroring really comes...

    April 21, 2014 at 2:30 pm

    #1707557

  • RE: Automating Database Restores

    JCAirey1 (4/21/2014)

    Cool script. What happens if @AutoExecute AND @IncludeSystemDatabases are both equal to 1? 🙂

    Hi JC,

    In case @AutoExecute & @IncludeSystemDatabases both are set to 1, procedure will throw following error:

    "AutoExecute...

    April 21, 2014 at 2:20 pm

    #1707555

  • RE: Automating Database Restores

    Perry Whittle (4/21/2014)

    Why not just use log shipping, seems it would be perfect for this scenario.

    Thanks for your comment Perry.

    You are absolutely right. Log shipping is also a very...

    April 21, 2014 at 7:44 am

    #1707449

  • RE: Automating Database Restores

    Due to some formatting issues in the article, RESTORE HEADERONLY & RESTORE FILELISTONLY commands are not visible in full.

    Complete commands are given below:

    Restore HeaderOnly:

    RESTORE HEADERONLY FROM DISK = 'D:\SQLTestLab\Backups\AdventureWorks_FULL_2014_04_03_18_11_23.BAK'

    Restore...

    April 21, 2014 at 4:59 am

    #1707399

  • RE: Truncate and Restores

    Steve\Gail,

    I have written something on it. I may submit it today. You can check if it is good to publish.

    P.S.: Like everybody else on SSC, I would always be interested...

    April 17, 2014 at 3:49 am

    #1706682

  • RE: Truncate and Restores

    Hi Steve,

    Are you asking for an article on Point-In-Time recovery or is there anything more than that?

    April 13, 2014 at 2:59 pm

    #1705613

  • RE: SQL Server Read ismore

    yuvipoy (4/7/2014)

    Divine Flame (4/7/2014)

    I am not sure if this syntax is supported yet:

    SELECT * FROM TableName WITH (DEADLOCK)

    "DEADLOCK" is not a recognized table hints option in SQL Server.

    So which database...

    April 7, 2014 at 9:44 am

    #1703857

  • RE: SQL Server Read ismore

    yuvipoy (4/7/2014)

    Those are the existing codes.

    i need to modify them.

    Yes using dead lock will lead to incorrect reports.

    :hehe:

    I am not sure if this syntax is supported yet:

    SELECT * FROM...

    April 7, 2014 at 8:18 am

    #1703802

  • RE: Is SMTP services or IIS is mandatory for Database mail?

    selvakumar.sms (3/12/2014)

    I restarted SQL Server Agent also.But no luck.

    As per your error description it seem that the mail account used to send the mails doesn't have the permission on the...

    March 12, 2014 at 5:16 am

    #1696311

  • RE: how to avoid index scan on this query

    kbhanu15 (3/12/2014)

    hi,

    for sample example i given this tamp table and sample results.

    the original query is different in my project.

    any other way to avoid this index scan.

    i need solution for issue.

    Thanks

    Bhanu

    Considering...

    March 12, 2014 at 5:09 am

    #1696305

  • RE: Is SMTP services or IIS is mandatory for Database mail?

    selvakumar.sms (3/12/2014)

    SMTP Server IP is configured in Database mail Account.but mail is not delivery.Any services i need to enable in the server ?

    From other server Database mail is working.

    Ensure you...

    March 12, 2014 at 4:39 am

    #1696297

  • RE: Is SMTP services or IIS is mandatory for Database mail?

    selvakumar.sms (3/11/2014)

    Hi,

    Server dont have SMTP serivce and IIS.

    Is SMTP and IIS is mandatory ?

    Thanks

    You need to ask your system or network administrator about the SMTP...

    March 12, 2014 at 3:42 am

    #1696272

  • RE: Subtract value 2 from value 1 in sql

    You may need to put it like this:

    with cte as

    (

    select userid, parentid from user_detail where userid = '100002'

    union all select t.userid, t.parentid

    from ...

    February 24, 2014 at 4:24 am

    #1691472

Viewing 15 posts - 61 through 75 (of 644 total)