TROUBLE WHERE RESTORING A DATABASE

• Fred Lankovich

  Grasshopper

  Points: 11

  More actions

  February 15, 2006 at 4:40 am

  #168243

  Hi, i have a db called BDinformix , The table's owners from this DB are : security and informix. When i take a backup from the db BDinformix to antoher computer running the same version of SQL Server, i could restore the db, but i forget to create the users (security and informix) before the restore (i made this after restore, so i couldnt delete the users from db). So if i want to make a query like :

  SELECT * FROM table1

  the server says "unknown object 'table1'" , but if i write

  SELECT * FROM informix.table1

  it works!! , so i was thinking "if i delete the users from Security->Logins and if I delete the db, i could do the process again , but i will create the users before restore the db, it will sure works " . But, it didn't work. I've been searching the web but nothing yet (i'm still searching) so any help would be a great healp for thi very very newbie

  Thanks a Lot

  Fred Lankovich

• David.Poole

  SSC Guru

  Points: 76151

  More actions

  February 15, 2006 at 4:56 am

  #620958

  See BOL for sp_addlogin example E.

  Basically create you Informix login on your new box so that it is identical to the Informix login on your old box.

  LinkedIn Profile