Solved

Cannot generate scripts for data after table move.

Posted on 2009-07-01
4
189 Views
Last Modified: 2012-05-07
I have a database called Materials.

The table was created in a database named DB1.  We needed to move it from DB1 to DB2.
I generated scripts of the table and data and recreated it in DB2.
I took DB1 offline.

Now I am trying to script the Materials table (and data) again.  However, I am getting a "Failed" error because it is saying that the script cannot be generated becasue DB1 is offline!!
It shouldn't matter that DB1 is offline because the table exists only in DB2 now.

How do I fix this so that I can generate the scripts??
0
Comment
Question by:PIERCGG
  • 2
  • 2
4 Comments
 
LVL 35

Expert Comment

by:YZlat
ID: 24754500
are you trying to script the table in DB1 or DB2?
0
 
LVL 6

Author Comment

by:PIERCGG
ID: 24754513
I am trying to script it in DB2.  DB1 is offline.
I need the one in DB2 because a lot of new data was added since it was originally moved.
0
 
LVL 35

Accepted Solution

by:
YZlat earned 250 total points
ID: 24754518
0
 
LVL 6

Author Closing Comment

by:PIERCGG
ID: 31598775
That's it!  That's the answer!  It is a bug that occurs if the db is offline.  The bug doesn't occur if you just go ahead and detach the db.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question