Post reply

t-sql help

  • February 4, 2012 at 11:40 am

    #267653

    I'm testing the below script.

    If I give the path name wrong, @hr variable giving some number (like 60405).

    Just want to know from where this number is coming?

    declare @hr int

    EXEC @hr = master.dbo.xp_backup_database

    @database =Mydb ,

    @filename = 'Z:\Spotlight_Backup\Mydb.lsbak' ,

    @init = 1,

    @threads=3,

    @verify = 1

    select @hr

  • February 4, 2012 at 12:41 pm

    #1442769

    if memory serves me correcting xp_backup_database is a Litespeed product and technically the error is from SQL Server and not lightspeed at the root of the failure, but lightspeed itself isn't just say 'hey your request failed' and setting the failure value of the result.

    So the next time it happens check BOL (Books On Line) or Microsoft's TECHNET for its meaning.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

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

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