Hi folks,
I'm trying to copy a database from my test eviroment to my production
enviroment using Copy SQL Server Objects Task and I have an error with a
tables that I deleted long time ago saying that they are missing.
Is anybody know a work around on this?
Tks
JFB

It apparently is caching the list. Have you tried just using Backup and
Restore or sp_attach_db?


http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scri...p?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server

http://www.support.microsoft.com/?id=274463 Copy DB
Wizard issues

--

Andrew J. Kelly
SQL Server MVP


"JFB" <jfb2002 (AT) directvinternet (DOT) com> wrote

In addition to Andrew's comments.
Does it appear in the list of objects you can transfer i.e. unselect "Copy
all objects". If not then does it appear referenced in any views/SPs ? If
you have "Include dependent objects" ticked it may be looking for this
table.



--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Andrew J. Kelly" <sqlmvpnooospam (AT) shadhawk (DOT) com> wrote

Tks for the comments Folks,
I did this yesterday like andrew said with backup and restore but i just
want to know why i'm getting this strange error.
Tks again
JFB

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Allan,
These tables doesn't appear in the list, also I didnt check "Include
dependent objects".
Do you any other idea how can I fix this?
I want to do this once a week and I want to avoid the manual process.
Tks again
JFB

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

I don't have an answer as to why it's happening but you can easily script
the Backup and Restore as well. No need to do it manually. Just create a
scheduled job and add the Backup and Restore code and you should be golden.

--

Andrew J. Kelly
SQL Server MVP


"JFB" <jfb2002 (AT) directvinternet (DOT) com> wrote