How to restore mdf file as backup database
I have my database saves as mdf , i want what is the steps to restore or create a new database using this mdf file. I tired to restore as usual, it shows error? Please help
View Answer
| Apr 23 2008 10:15 AM GMT
| asked by
Thrstorm
Restore, MDF, Database
HOw do I restore a database from a backup in MS SQL Server 2000
I have no knowledge of MS SQL Server. Have software (BOOMI) that uses a database in this. I found a folder where the database is being backed up. i.e. there is a *.BAK file and hourly logs *.TRN. I need to update the boomi software and they say I need to make a back up of the database. If this is...
View Answer
| Mar 25 2008 11:46 AM GMT
| asked by
Arlocoder
Restore, Boomi, SQL Server backup
Restoring Databases
Sir, I have deleted a table in sql database.Is there any option to recover it without losing the data.Please reply
View Answer
| Mar 17 2008 6:57 AM GMT
| asked by
H100
Restore, SQL Server, SQL Server database restore
restoring deleted data and emails and tracking ip addresses in north america / england
Who are the best individuals to technically assist in restoring user level deleted data from Windows OS / Mac OS X and to track ip addresses ? contact--digitall1@aol.com
View Answer
| Mar 16 2008 4:29 AM GMT
| asked by
Digitall1
Restore, Backup & recovery
Stored Procedure for dropping indexes
I would like a stored procedure that will take as input the name of a table. Whatthe procedure would do is drop all indexes on that table excpet any index that ends with U1 or P1, and save the information on the ones it drops.Then I would like another strored procedure that takes a table name as...
View Answer
| Feb 28 2008 4:04 PM GMT
| asked by
Dangagne
Indexes, DROP, Restore
Recovering and restoring database
I have taken a rman backup without controlfiles and i am not using recovery catalog i am uisng target database.NOw i lost all datafile s,controlfiles and redolog files.How do i get my databse up and running.
Answer Question
| Nov 30 2007 7:03 PM GMT
| asked by
Plmokn
Restore, Recovery, Recovery Manager
SQL 2005 Restore DB with Multiple files in Primary File group
Is it possible to take a backup of a database that has multiple files within the primary file group (10 total in this example)and restore that backup to a new database that has only one file in the primary file group?THanks,Lee
View Answer
| Nov 6 2007 8:58 PM GMT
| asked by
Leeland
Restore, Database, SQL
