But it doesn't restore anything? as the backups are for databases that do not exist on the server, they only exist on the old server?
use master
EXEC sp_ABRestoreDb '{UserDbs}', '\ewcpnt12\restore\Databases\&\&_db_*'
GO
outputs this
Server: Msg 50000, Level 16, State 1, Procedure sp_ABRestoreDb, Line 341
Filespec \ewcpnt12\restore\Databases\AeroConf\AeroConf_db_* did not match any files
aeroconf is the only user db that exists on the new server.
This was my point - how does it know it is a userdb from a .bak file?
sorry if I am a pain in the behind - very grateful for your help