Forum Replies Created

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

  • 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

  • RE: I messed up Quorum and MSDTC drive switch on failover cluster

    So far as I know, cluster resources can be deleted and recreated without affecting the actual physical disks. As far as the drive letters go, they are based on OS...

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

    #1811342

  • RE: Maintenance Cleanup Task not cleaning up

    Does the SQL service account have permissions on the drive / folder in question?

    Are the files younger or older than 4 weeks old?

    Is it pointing to the correct folder?

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

    July 9, 2015 at 6:49 am

    #1811277

  • RE: Connectionstring with SERVER=myserverAddress

    philosophaie (7/9/2015)

    In 2012 R2 in server "WIN-1" I have installed a copy of SQL Server 2012. I have added RDSCB into DNS Manager with a IP Address one up...

    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 6:46 am

    #1811276

  • RE: Connectionstring with SERVER=myserverAddress

    philosophaie (7/9/2015)

    Error code from RD Connection Broker - Configure High Availability: "write permission to sql database"

    How do you create "RD Connection Broker having write permission to sql database"?

    I haven't worked...

    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 6:31 am

    #1811265

  • RE: SSIS Transfer SQL Server Objects Task

    Update your package to include IF NOT EXISTS before you create the objects. That should avoid your errors.

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

    #1811257

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