General Question

Ranimi23's avatar

How to solve this problem I have with a restore (backup) file I made in SQL Server 2008?

Asked by Ranimi23 (1881 points ) March 31st, 2010

I have made a time ago a file backup in SQL Server 2005. Now, I am using SQL Server 2008. I made a restore to that file and everything went fine. But, every time I’m trying to add a new table to my DB I get this message I can’t understand why:

“Saving changes is not permitted. The changes you have made require the following table to be dropped and re-created. You have either made changes to a table that can’t be re-created or enabled the option Prevent saving changes that require the table to be re-created”

and I get in list only the new table I just added.

I don’t know what this means at all. I only added one table, no primary key, no connections, nothing else and it refuses to make the change and save it, so now I’m stuck and can’t change anything on my DB.

How can it be?
What may be the problem?
Please help and advise :-(

Observing members: 0 Composing members: 0

7 Answers

baxter's avatar

try to see if you have volume optimization enabled, it prevents certain changes from happening and really gives the user a hell of alot more trouble than it is worth.

Ranimi23's avatar

@baxter , What is the volume optimization?
Where should I find it? Properties?

baxter's avatar

actually I misread the question, for some reason I thought it was backup exec. but I’ve had the same recurring issue on different SQL servers. See if this helps you
http://www.sql-server-performance.com/faq/saving_changes_not_permitted_p1.aspx

Ranimi23's avatar

@baxter 10X A LOT (!)
You have made my day. I have lost my mind over this problem.
Thank you so much.

baxter's avatar

Happy to help.

Response moderated (Spam)
Response moderated (Spam)

Answer this question

Login

or

Join

to answer.

This question is in the General Section. Responses must be helpful and on-topic.

Your answer will be saved while you login or join.

Have a question? Ask Fluther!

What do you know more about?
or
Knowledge Networking @ Fluther