Results 1 to 1 of 1
  1. #1
    Join Date
    Jun 2004
    Location
    London
    Posts
    3

    Unanswered: How can I see if backup_server is running as login 'user' from sp_proc on proddb

    How can I check if backup_server is running as login 'userdba' from sp_proc on prod_db?

    I wanna check that it's up and running from within my SQL sproc
    then Check that its logged in as login 'userdba'
    so that the dump to a specific area which _BS in "UP" state will recognise.

    if its up and logged in as ....userdba then
    dump............stripe on '\\dumparea\dumpsite'

    else dump to hardcoded area...


    I can't think
    Last edited by liezlnel; 01-26-06 at 14:52. Reason: Duplicate - my apologies

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •