Forum Replies Created

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

  • RE: Backup when mssqlservice is stopped

    CirquedeSQLeil (4/29/2010)

    MS CRM is one such application that does this. It permits end users to create new organizations (it can also be scheduled to do it automatically) - which...

    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:50 am

    #1159898

  • RE: Disaster Recovery Questionaire

    There is a difference between Disaster Recovery and Business Continuity. You need to define which your client wants to do.

    Iron Mountain Records Management has very good white papers on both...

    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:47 am

    #1159897

  • RE: Backup when mssqlservice is stopped

    haakon 29117 (4/29/2010)

    Our trouble is that we have a application witch generates a lot ammount of databases. We are now past about 2700 databases.

    Please tell me what this application is...

    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:42 am

    #1159889

  • 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

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