Post reply

backup query result

  • July 23, 2015 at 3:05 am

    #398787

    Hello, there is a need to make backup query result. Can you suggest an easy way, please?

  • July 23, 2015 at 3:10 am

    #1814294

    Could you please explain in a bit more detail what it is you need?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 23, 2015 at 3:42 am

    #1814296

    There is an situation where i need to backup the results of a query of several tables.

  • July 23, 2015 at 3:48 am

    #1814298

    Repeating the question doesn't really help with giving more detail. Could you explain the problem in more detail please?

    What are you trying to do? What problem are you trying to solve? What are you needing to do with the 'backup'? The more detail the better.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 23, 2015 at 4:17 am

    #1814312

    GilaMonster (7/23/2015)

    Repeating the question doesn't really help with giving more detail. Could you explain the problem in more detail please?

    What are you trying to do? What problem are you trying to solve? What are you needing to do with the 'backup'? The more detail the better.

    Thanks,

    I need to backup data from a query. I think about this:

    BACKUP DATABASE 'sourceDB'

    Select * from Table where Day = '20.07.2015';

    TO DISK = 'F:\Program Files\Microsoft SQL Server\MSSQL\Backup\sourceDB.bak' WITH FORMAT

  • July 23, 2015 at 4:31 am

    #1814320

    Repeating exactly the same thing again and again isn't giving me more detail!

    A backup is of a database, an entire database, not a query. You cannot put a select into a backup statement

    What problem are you trying to solve here? What do you need to do with the saved results?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 23, 2015 at 5:50 am

    #1814336

    Thanks Gila, i found out solution to my question.

  • July 23, 2015 at 7:25 am

    #1814360

    GilaMonster (7/23/2015)

    Repeating exactly the same thing again and again isn't giving me more detail!

    A backup is of a database, an entire database, not a query. You cannot put a select into a backup statement

    What problem are you trying to solve here? What do you need to do with the saved results?

    Apparently, for this user, it DOES lead to a solution... and here's the evidence...

    williamsandrew144 (7/23/2015)

    Thanks Gila, i found out solution to my question.

    Who knew ??? 😀 :w00t: :hehe: :w00t: 😀 :w00t: :hehe:

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply