Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lwibisana
Starting Member
2 Posts |
 Posted - 2011-05-09 : 14:32:41
|
| Hi,is there any way to recover a database? I accidently drop my database .I don't have any backup. much appreciate your help. |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-05-09 : 14:34:05
|
| Nope - the drop will have deleted the files.Unless you can recover the files from the O/S you are stuck.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
lwibisana
Starting Member
2 Posts |
Posted - 2011-05-09 : 14:41:06
|
| thanks for your prompt reply. I'll have to look other way. |
|
|
|
prett
Posting Yak Master
212 Posts |
Posted - 2011-05-13 : 04:55:16
|
| The Best way to recover a database in the absence of backup is use of SQL Recovery Software. These software are very easy to use & made for technical users as well for novice users. |
|
|
|
granuharmot
Starting Member
31 Posts |
Posted - 2014-09-23 : 05:03:57
|
| unspammed |
|
|
|
Rasmus.Hald
Starting Member
1 Post |
Posted - 2014-12-02 : 11:08:57
|
| Try this site: https://social.msdn.microsoft.com/Forums/en-US/6562f8be-1916-491c-a69c-e8904c3b9251/sql-database-recovery-from-corrupt-database-file?forum=sqltoolsor try this steps..i ho it ll be helpful• Click the Windows "Start" button and select "All Programs." Click "SQL Server," then click "SQL Server Integration Services SSIS." This opens the SSIS wizard that starts the import process.• Choose "Integrated Service Project" from the list of options. Type a name for the project and click "OK." The project files are created on your desktop. Click "Flat File Source" in the list of file source objects and click "Next."• Click the "New" button. A new window opens where you select the flat file on your hard drive. After you select the file, several options are displayed below the flat file name. Leave the default values and click "Next."• Click "OLE DB Destination" in the left panel. This sets the type of database connection to transfer the data. Click "Browse" to open a new window. Click the database server name and click "OK." If you need a user name and password to access the server, type it in the text boxes. Click "Next."• Review the settings on the final screen and click "Run." The flat file imports to the SQL Server. This may take several minutes, depending on the size of the flat file. |
|
|
|
|
|
|
Database recovery