I am trying to restore from a backup to a new database, and it processes for 8 hours and completes to 100%, and i get the following error. 100 percent processed. Msg 3013, Level 16, State 1, Line 1 RESTORE DATABASE is terminating abnormally. Msg 701, Level 17, State 123, Line 1 There is insufficient [...]
Answer Question | March 2, 2012 3:10 PM
SQL Query, SQL Server 2008, SQL Server 2008 error messages, SQL Server database restore, SQL Server restore
Hi, We have been ask by one of our customer to restore a database from SQL Server 2000 and SQL Server 2005. The restore completed however when we run a integrity check on the database errors occurred. We than ran an integrity check with repair allow data loss option, as the customer is happy to [...]
Answer Question | September 16, 2009 11:15 AM
DBCC, DBCC CHECKDB, SQL Server 2005, SQL Server database restore
When i restore a database from server1 to server2 as stand by/read-only mode the database restores with a database owner “domainrmartinez”. How can i restore a database from server1 to server2 and the database owner as “sa”?
Answer Question | September 4, 2009 9:21 PM
SQL Server, SQL Server 2005, SQL Server administration, SQL Server database, SQL Server database restore
I’m working with SQL Server 7 and I made a backup from a DataBase and I need to restore it, but this error appear: “The RAID set for database is missing member number 1″. What can I do???
Answer Question | December 2, 2008 2:00 PM
RAID, SQL Server 7.x, SQL Server database, SQL Server database restore, SQL Server errors
How can I restore a SQL database with an .mdf file?
Answer Question | May 5, 2012 3:32 PM
MDF, SQL Server database, SQL Server database restore
I have a 100+ db that was hacked. The column level constraints/defaults were removed. I’d like to know how I can reapply the constraints/defaults while keeping the data intact. I do have an identical database with no data in it.
Answer Question | September 26, 2008 1:26 PM
SQL Server 2005, SQL Server database, SQL Server database restore
How can I restore a database from .mdf file? I only have .mdf backup file.
Answer Question | April 19, 2013 12:01 AM
SQL Server backup, SQL Server database restore
Sir, I have deleted a table in sql database.Is there any option to recover it without losing the data.Please reply
Answer Question | March 17, 2008 6:57 AM
Restore, SQL Server, SQL Server database restore
I have installed a SQL Server 2005 IBM Rational RequisitePro DB into my local SQL Server 2008. Can I restore this database back to the SQL Server 2005 box? I know this was a problem when going from SQL Server 2005 to 2000.
Answer Question | March 7, 2008 10:47 PM
SQL Server 2005, SQL Server 2008, SQL Server database restore