![]() I then went through a time consuming process to remove the partitions functions and schemes, and could successfully restore the database on the Standard edition.Īfter a while I backed up the DB (with no PFs or PSs), transferred it to my dev env, restored it (on SQL Enterprise), and after some time I found that a single partition function and scheme had been created. When I dug deeper, I found that it appeared that FTS or some other function had automatically created 5 partition functions and schemes. However when I restored the DB it failed to activate, and in the Event Log, I found a message indicating the database couldn't be activated because it contained features not supported by the version. I didn't think it should be a problem, as I hadn't implemented any enterprise specific features. ![]() ![]() I have been developing against SQL Server 2012 Enterprise, and came to migrate to production, where I found our hosting provider had installed Standard. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |