Forum Replies Created

Viewing 15 posts - 2,506 through 2,520 (of 9,720 total)

  • RE: Maintenance Cleanup Task not cleaning up

    Jacob Wilkins (7/9/2015)

    What are the extensions of your backup files?

    The parameter for file extension is blank, so it would only delete any backup files that don't have an extension. If...

    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.

    July 10, 2015 at 4:31 am

    #1811545

  • RE: Are the posted questions getting worse?

    Help. The OP keeps asking questions about HA that I can't answer. I know they doesn't understand the stuff they're finding on the internet, but at least (finally) they're trying...

    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.

    July 10, 2015 at 4:27 am

    #1811543

  • RE: Are the posted questions getting worse?

    So I've been a DBA for eleven years now. In the past three days, I have learned twelve new things I never knew (but should have known) about SQL Server.

    This...

    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.

    July 9, 2015 at 12:33 pm

    #1811424

  • RE: Connectionstring with SERVER=myserverAddress

    philosophaie (7/9/2015)

    How do you find the SQL Login in SQL Server manager?

    http://social.technet.microsoft.com/wiki/contents/articles/10393.rd-connection-broker-ha-sql-permissions.aspx

    Open up SSMS. Navigate to Security -> Logins. It should be there.

    Those are the server level logins. If it's...

    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.

    July 9, 2015 at 12:32 pm

    #1811423

  • RE: SQL 2012 Install silently fails after term acceptance

    Eirikur Eiriksson (7/9/2015)

    Quick questions, what is the .Net version on the box? Can you install the latest .Net if not already there? It's just a hunch but have the latest...

    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.

    July 9, 2015 at 12:26 pm

    #1811420

  • RE: SQL 2012 Install silently fails after term acceptance

    Brandie Tarvin (7/9/2015)

    EDIT: I am adding this link for my own future reference. I used this to fix the Upgrade Advisor. Unfortunately, it's not working on the Setup Files. I...

    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.

    July 9, 2015 at 12:25 pm

    #1811419

  • RE: SQL 2012 Install silently fails after term acceptance

    Alvin Ramard (7/9/2015)

    Unfortunately, the version of SQL I had didn't come with an install option that would tell it to ignore everything and just install anyway.

    I couldn't uninstall because...

    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.

    July 9, 2015 at 12:00 pm

    #1811413

  • RE: Are the posted questions getting worse?

    Alvin Ramard (7/9/2015)

    Brandie Tarvin (7/9/2015)

    Let the head banging commence. Any thoughts on my issue here?

    Brought back a not so pleasant memory. Hope you find a better solution.

    Thanks, Alvin.

    If...

    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.

    July 9, 2015 at 11:57 am

    #1811412

  • RE: SQL 2012 Install silently fails after term acceptance

    Alvin Ramard (7/9/2015)

    I had an issue like this once why setting up a new desktop. I ended up reinstalling Windows and everything else. 🙁

    If the OS needs reinstalling, I...

    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.

    July 9, 2015 at 11:39 am

    #1811404

  • RE: Are the posted questions getting worse?

    Let the head banging commence. Any thoughts on my issue here?

    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.

    July 9, 2015 at 11:17 am

    #1811397

  • RE: SQL 2012 Install silently fails after term acceptance

    Okay, I think I've figured out part of the problem. The SQL Server 2012 Setup Files are still partially installed. There were two versions in the Programs and Features and...

    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.

    July 9, 2015 at 11:13 am

    #1811396

  • RE: SSIS: Dynamic updating of a recordset variable

    BTW, you do know how to use annotations to document an SSIS package, right?

    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.

    July 9, 2015 at 11:00 am

    #1811391

  • RE: SSIS: Dynamic updating of a recordset variable

    So your own process prevents you from using the full suite of SSIS tools to accomplish your task?

    That seems a little excessive to me. But yes, if you can't use...

    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.

    July 9, 2015 at 10:59 am

    #1811390

  • RE: BackUp/Restore Options

    Assuming you've ensured that your test DB restore to production will never overwrite an active production db...

    You can script this out into a job. It's just a simple T-SQL...

    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.

    July 9, 2015 at 8:57 am

    #1811348

  • RE: Backups

    GilaMonster (7/9/2015)

    Welsh Corgi (7/8/2015)

    What do you consider best practices?

    Designing a backup strategy that meets the company's RPO, RTO and maintenance windows.

    It's all well and good for you to say 'I...

    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.

    July 9, 2015 at 8:50 am

    #1811344

Viewing 15 posts - 2,506 through 2,520 (of 9,720 total)