Forum Replies Created

Viewing 15 posts - 8,026 through 8,040 (of 9,707 total)

  • RE: tapebackups

    You'd have to look at the tape-related software for that answer.

  • RE: SQL Server table backups location

    I don't think the Copy-Only Backups get stored in the tables, though. Do they?

  • RE: Capture Messages

    If you don't need to see the messages at the time the proc is run, Insert them into some sort of log table. If you do need to see the...

  • RE: Perofrmance Test

    Tara-1044200 (4/29/2010)


    Is there any other best way to test which helps me to decide whether or not to go with the plan ?

    Run PerfMon and a server-side Profiler trace on...

  • RE: Filegroup ALERTS and TRANACTION LOG FULL ALERTS

    Bhuvnesh (4/28/2010)


    chanti2985 (4/28/2010)


    tlogbackup-everyday except sunday

    full backup-sunday

    Not an ideal Backup strategy, Include differentail back up also and change the Tlog backup frequency to One hour. Additionally read the articles related...

  • RE: Can't lauch SQL Server Managment Studio after i am connected via VPN

    Are there global policy restrictions on launching applications from entry through a VPN tunnel?

    Could the VPN tunnel be such a memory hog that the system doesn't have the resources to...

  • RE: Log shipping standby database - how to fix broken users

    If you've already got the users set up in the Target server, don't worry about deleting and creating. As suggested earlier, just use sp_change_users_login and that will fix the database.

    However,...

  • RE: sql server.exe

    Rectify it? Why? Is it actually causing you a problem?

    If so, please describe the problems it's causing. If you're just concerned because you've seen it increase memory utilization and you...

  • RE: Server Services

    NJ-DBA (4/29/2010)


    The SQL Server Service and Agent Service should NOT be set to automatic- if so, on startup, those services will attempt to start on both nodes.

    The Cluster Service should...

  • RE: Server Services

    I'm not quite sure I understand the question, but I'll try.

    If you add SQL Services to the cluster administrator tool, you should absolutely make sure they are set to restart....

  • RE: Encrypting the entire database.

    I agree with thoughts that this could be a misinterpretation of the situation. If an entire database needs encrypting, my thought is that NO ONE should have access to it....

  • RE: Please Solve This query

    My take on this post is (s)he wants us to build the actual database.

    Read Books Online. It has all sorts of useful information on how to do this task.

  • RE: Drop and recreate vs alter stored procedure

    I'll have to check into that myself. I never bothered to look and we do need that info.

    Thanks, Lynn & Grant.

  • RE: Tempdb GROWS

    Your best bet is to run a day long session of Profiler and PerfMon to identify your issues.

    Or have both run sample traces every X number of minutes. But that's...

  • RE: Tempdb GROWS

    2cams (4/28/2010)


    MANU-J. your query gives me NULL in all the rows listed ...

    If you're getting NULLS, there's not a whole lot happening. But just an FYI, MANU-J is using an...

Viewing 15 posts - 8,026 through 8,040 (of 9,707 total)