Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004

    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

  2. #2
    Join Date
    Feb 2002
    Willy is on vacation
    Backup Server in itself does not perform any login credentials check. As long as the BS is started by the same UNIX login as the dataserver, you are fine.

    You will find that you can log into backup server like you do on the dataserver using pretty much any login that you want. However, there is nothing you can do at the prompt(well, very limited which are not documented), not even a shutdown.

    So to the right check for you to gurantee that dump will work is to make sure that the owner of the pid for dataserver and BS is the same. This can be done using fuser

Posting Permissions

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