Forum Replies Created

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

  • RE: SQL query help please

    More details are definitely needed on the whole "not working out" statement.

    Given your statement about JOINS taking care of the recordset and not needing a WHERE clause makes me think...

    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 11:28 am

    #1159933

  • RE: When is a function used

    The best way to monitor object useage is through a Profiler Trace. Server-side is more efficient that GUI version, but either works. Filter your trace to look only for 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 11:23 am

    #1159928

  • RE: Error in SSIS Package

    Google this phrase only:

    SSIS A network-related or instance-specific error has occurred while establishing a connection to SQL Server

    You'll come up with PLENTY of links.

    Things you should look into off...

    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 11:20 am

    #1159927

  • RE: Timout expired when logging in from client SSMS

    Server Properties, Advanced. Remote Login Timeout.

    Hope that helps.

    You might also want to check the Event logs when this happens to see if they'll tell you anything you don't 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 11:10 am

    #1159921

  • RE: Product Feedback - Idera SQL Virtual Database

    You might want to repost this in the Admininstrating General Discussion forum. The backup forum might not be haunted by the people who have the answers you want.

    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 11:05 am

    #1159917

  • RE: Backup when mssqlservice is stopped

    Lynn Pettis (4/29/2010)

    SharePoint (MOSS) is another one. You can create multiple content databases.

    I can actually see that being useful and not growing to monsterous proportions if it's admined...

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

    #1159911

  • RE: Where are you?

    You are a cruel, cruel man, John Rowan....

    @sigh.

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

    #1159906

  • 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

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