At Fixya.com, our trusted experts are meticulously vetted and possess extensive experience in their respective fields. Backed by a community of knowledgeable professionals, our platform ensures that the solutions provided are thoroughly researched and validated.
Hi, my name is alberto.....I have posted a solution for the Creating database problem.... I think the problem could be the WMA files.....It seems this mp3 player doesn't like this kind of files.... Regards, Alberto i nave the same problem
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
Perform following steps to recover sql server database:
Create a database with same size that you are trying to recover
Shutdown the SQL server
Swap old mdf file with new mdf file
Start the SQL server
Database may go in suspect
Set database in emergency mode
Run DBCC CHECKDB with repair_allow_data_loss to repair database
USE [master] GO ALTER DATABASE [RdmStoreInformation] SET EMERGENCY GO ALTER DATABASE [RdmStoreInformation] SET SINGLE_USER GO DBCC CHECKDB ([RdmStoreInformation], REPAIR_ALLOW_DATA_LOSS) GO ALTER DATABASE [RdmStoreInformation] SET MULTI_USER GO ALTER DATABASE [RdmStoreInformation] SET ONLINE
I suggest you use the Enterprise manager (gui tool to manage SQL).
Restoring a single table is not an option.
You can however restore a file or filegroup.
Make sure to backup before you start and NOT to restore database to its original name or original file location, to avoid acidents.
Normally you will have databases with only 2 files: the data at its Primary file group, and log file.
You may wish to create a new file group and move tables to the new group by recreating them there and exporting data from old table to new table. Then recreate indexes. This may prove to be complex as all tables and indexes have unique names and can't coexist with exact duplicate of them.
oh yea..... did I say backup?
well just in case backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup
but dont overwrite that backup
try creating (if you have not already tried) the exact folder tree as [I:\DESKTOPPC\DesktopPC\Database\Toby3]. Now put the file "Tonys_work_be.mdb" into the folder named "Toby3".
×