Gidget Posted April 27, 2012 Share Posted April 27, 2012 I am in kind of a bind. Every week I restore our production Database into a different database on a different Server for viewing by the users. Both Server are Windows boxes running V9.5 Usually a just do a redirected restore but the datbase is growing by eaps and bounds so this week I decided to drop the target database and then recreate it fresh, set the tablespace and then restore. I dropped the target database and now I cannot recreate it in that instance. when i try and recreate it I get this error: SQL1005N The database alias "dutdm" already exists in either the local database directory or system database directory. I have tried catloging and uncataloging the target database in the instance.. whatever I try it just says the database does not exist. Can anyone help????? Link to comment Share on other sites More sharing options...
ChuckTesta Posted April 27, 2012 Share Posted April 27, 2012 I call foul with this post.... You seem to be copy/pasting from a bunch of random sites. For example, this post is VERY similar to I am in kind of a bind. Every week I restore our production Database into a different database on a different Server for viewing by the users. Both Server are Windows boxes running V9.5 Usually a just do a redirected restore but the datbase is growing by eaps and bounds so this week I decided to drop the target database and then recreate it fresh, set the tablespace and then restore. I dropped the target database and now I cannot recreate it in that instance. when i try and recreate it I get this error: SQL1005N The database alias "dutdm" already exists in either the local database directory or system database directory. I have tried catloging and uncataloging the target database in the instance.. whatever I try it just says the database does not exist. Can anyone help????? And here is the link to the ORIGINAL source: http://www.ibm.com/developerworks/forums/thread.jspa?messageID=14275798 What's the reason for this? Link to comment Share on other sites More sharing options...
Administrators Nathan Posted April 27, 2012 Administrators Share Posted April 27, 2012 Busted Gidget. Link to comment Share on other sites More sharing options...
Recommended Posts