How do you guys backup the MSSQL database?
Because the only method i have found that works is using the SQL Tools in Visual Studio, then i compare the schema and then data.
Then it works, but is there a better way that is faster?
Because i just script the database within MSSQL Management Studio and taking schema and data then it looks like it works, BUT when i then try to create a new item or save an existing item in the Umbraco backend it gives me an error
Received an error from the server
An error occurred
Cannot insert the value NULL into column 'id', table 'WorldCareers.dbo.cmsContentVersion'; column does not allow nulls. INSERT fails.
The statement has been terminated.
EXCEPTION DETAILS:
System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'id', table 'WorldCareers.dbo.cmsContentVersion'; column does not allow nulls. INSERT fails.
The statement has been terminated.
I get this error after an "Import/Export" in MSSQL when i try to update or insert a new node.
How should scripts be created?
Because if i try to use a generated script it gives me error with relations :-/
Backup MSSQL db
Hi,
How do you guys backup the MSSQL database? Because the only method i have found that works is using the SQL Tools in Visual Studio, then i compare the schema and then data.
Then it works, but is there a better way that is faster?
Because i just script the database within MSSQL Management Studio and taking schema and data then it looks like it works, BUT when i then try to create a new item or save an existing item in the Umbraco backend it gives me an error
Hi Anders
Hmm, usually scripting the db seems to be working fine - What does the error message you get say?
/Jan
When i script the db, it also works fine but when i want to edit a page it gives me and error with Identity :-(
Hi Anders
But what kind of error? What does the error say? Screendump or copy/paste perhaps? :)
/Jan
Oh i see xD
I can't remember what it says other then the identity error, and i haven't much time to make it display the error :-(
Hi Jan :-)
The error i get is the following
I get this error after an "Import/Export" in MSSQL when i try to update or insert a new node.
How should scripts be created? Because if i try to use a generated script it gives me error with relations :-/
is working on a reply...