We are using SQL server 2008. Today during a restore the server ran out of disk space. After the Sys Admin remidied that problem, another problem still exists. The database still thinks it is being restored. The word "Restore" appears in parenthesis next to the databases name in SSMS.
I have a good backup copy (Actually I was trying to overwrite this databalse with backup from another database). How do I stop the failed restore?
Can I stop SQL server, delete the MDF and LDF and restart the service? What is the best method to fix this mess.
With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…