Forum Replies Created

Viewing 15 posts - 1,816 through 1,830 (of 9,725 total)

  • RE: Are the posted questions getting worse?

    Grant Fritchey (4/28/2016)[/b]

    Technical question:

    I want to export large amounts of data. However, I don't want to use SSIS. I'm going to use SQLCMD.EXE. I need to be able to script...

    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 28, 2016 at 8:26 am

    #1875284

  • RE: Are the posted questions getting worse?

    Grant Fritchey (4/28/2016)

    Brandie Tarvin (4/28/2016)

    Grant Fritchey (4/28/2016)

    Technical question:

    I want to export large amounts of data. However, I don't want to use SSIS. I'm going to use SQLCMD.EXE. I need 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 28, 2016 at 8:12 am

    #1875272

  • RE: Are the posted questions getting worse?

    Grant Fritchey (4/28/2016)

    Technical question:

    I want to export large amounts of data. However, I don't want to use SSIS. I'm going to use SQLCMD.EXE. I need to be able to script...

    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 28, 2016 at 8:01 am

    #1875263

  • RE: Are the posted questions getting worse?

    TomThomson (4/26/2016)

    Steve Jones - SSC Editor (4/26/2016)

    See you there, and...

    you have a car? I thought everyone in the UK just used trains.

    Trains? UK rail fares are by far 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 27, 2016 at 8:11 am

    #1874949

  • RE: db_backupoperator can't back up database

    Jacob Wilkins (4/26/2016)

    That DENY didn't show up in the results of the query I posted earlier?

    It should have, so I'm curious why it didn't.

    I just remembered. There was so...

    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 26, 2016 at 11:46 am

    #1874732

  • RE: db_backupoperator can't back up database

    Steve Jones - SSC Editor (4/26/2016)

    wow, deny to public. That would have been low, low on my list.

    Good catch, Brandie.

    I hate anyone that adds any permissions to public. Please, please,...

    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 26, 2016 at 11:42 am

    #1874728

  • RE: db_backupoperator can't back up database

    Jacob Wilkins (4/26/2016)

    That DENY didn't show up in the results of the query I posted earlier?

    It should have, so I'm curious why it didn't.

    Cheers!

    No, it did not, actually. Weird...

    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 26, 2016 at 11:40 am

    #1874723

  • RE: db_backupoperator can't back up database

    Thank 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 26, 2016 at 11:38 am

    #1874719

  • RE: Are the posted questions getting worse?

    yb751 (4/26/2016)

    Speaking of Kylo throwing a tantrum...

    https://youtu.be/s74breoNAKc

    Best Kylo Ren Twitter account ever.

    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 26, 2016 at 11:34 am

    #1874715

  • RE: db_backupoperator can't back up database

    Lynn Pettis (4/26/2016)

    Brandie Tarvin (4/26/2016)

    [headdesk]

    Seriously. SERIOUSLY?

    Because Public had a DENY on BACKUP DATABASE, it wouldn't let my account backup the database. I found it using the below code from 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.

    April 26, 2016 at 11:04 am

    #1874707

  • RE: db_backupoperator can't back up database

    Lynn Pettis (4/26/2016)

    Can you recreate the issue with a sandbox database in a test/development environment?

    This is our test environment. We're testing the vendor move to SQL 2012 before moving 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 26, 2016 at 11:02 am

    #1874706

  • RE: db_backupoperator can't back up database

    [headdesk]

    Seriously. SERIOUSLY?

    Because Public had a DENY on BACKUP DATABASE, it wouldn't let my account backup the database. I found it using the below code from this link.

    SELECT b.name, CASE a.protecttype...

    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 26, 2016 at 11:01 am

    #1874704

  • RE: db_backupoperator can't back up database

    Hrmpf.

    Nope. Doesn't fix it. Still with the permission error on BACKUP DATABASE. And the backup command works. I've printed it out to the job log and run it myself. So...

    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 26, 2016 at 10:52 am

    #1874698

  • RE: db_backupoperator can't back up database

    Lynn Pettis (4/26/2016)

    Found this doing a search:

    If you will assign user as db_backupoperator you will discover error when you will try to create a backup..

    When trying to specify location, 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 26, 2016 at 10:47 am

    #1874697

  • RE: db_backupoperator can't back up database

    Steve Jones - SSC Editor (4/26/2016)

    Log

    user_name()

    suser_sname()

    etc. (there are a few more)

    into a table before the app runs the command (and the command). Check there isn't any impersonation.

    We...

    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 26, 2016 at 10:33 am

    #1874693

Viewing 15 posts - 1,816 through 1,830 (of 9,725 total)