Forum Replies Created

Viewing 15 posts - 8,041 through 8,055 (of 9,725 total)

  • RE: Backup when mssqlservice is stopped

    haakon 29117 (4/29/2010)

    1 - If we stop the sqlservice with the following command: net stop /y mssqlserver , would all the information in the log files be written to the...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    April 29, 2010 at 10:37 am

    #1159885

  • RE: Mirroring connection timeout for db

    dallas13 (4/29/2010)

    I was able to see the improvements after this. It worked for me.

    But every time after failover this value again gets set to 10 sec

    so you need to change...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    April 29, 2010 at 10:31 am

    #1159882

  • RE: Where are you?

    bklein2 (4/29/2010)

    Oh Yes!! With the wonderful Chocolate Dessert Bar. You have to take plenty of money with you to eat there.

    OKAY, THAT'S IT!!! ..... I wish I'd know...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    April 29, 2010 at 10:27 am

    #1159877

  • RE: tapebackups

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

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    April 29, 2010 at 8:54 am

    #1159776

  • RE: SQL Server table backups location

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

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    April 29, 2010 at 8:53 am

    #1159773

  • 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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    April 29, 2010 at 8:47 am

    #1159765

  • 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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    April 29, 2010 at 8:40 am

    #1159756

  • 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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    April 29, 2010 at 6:28 am

    #1159599

  • 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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    April 29, 2010 at 6:25 am

    #1159598

  • 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,...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    April 29, 2010 at 6:22 am

    #1159597

  • 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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    April 29, 2010 at 6:17 am

    #1159595

  • 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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    April 29, 2010 at 6:17 am

    #1159594

  • 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....

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    April 29, 2010 at 6:07 am

    #1159587

  • 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....

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    April 29, 2010 at 5:52 am

    #1159577

  • 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.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    April 29, 2010 at 5:48 am

    #1159574

Viewing 15 posts - 8,041 through 8,055 (of 9,725 total)