Question about Microsoft SQL Server 2000 Standard Edition for PC

4 Answers

Restoring files from the database

Im running sql server 2000 on windows server 2000 and im backing up with symantec backup exec 10d. All my backups are working fine but im trying to work out how to restore 1 file or table in the database rather than all the database. when i go thru the restore i can only select my sql server database as a full backup.

any help would be appreciated
thanks

Posted by on

4 Answers

  • Level 1:

    An expert who has achieved level 1.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 8 Answers
  • Level 1:

    An expert who has achieved level 1.

    MVP:

    An expert that got 5 achievements.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that has over 10 points.

  • Contributor
  • 33 Answers

Few days ago, deleted my some SQL database then I used RecoveryFix for SQL recovery software. This software recover my all deleted data from SQL database. For more details you can download demo version: http://www.mdf.repairsqlserver.net/
For more information read this post: http://diskdatarecovery.jimdo.com/2013/07/23/how-to-restore-lost-data-on-server-while-running-sql-server/

Posted on Apr 29, 2014

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Champion:

    An expert who has answered 200 questions.

    Governor:

    An expert whose answer got voted for 20 times.

  • Microsoft Expert
  • 401 Answers

Determining given trouble can be mdf recovery. It can fix sql databases after power failures, viruses, hacker attacks. The utility works under any Windows OS. It can work with big mdf files and starts under low system requirements.

Posted on Oct 05, 2011

  • Level 1:

    An expert who has achieved level 1.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 6 Answers

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

Posted on Dec 21, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2 Answers

Creating a new database using an MDF file


An MDF file isn't a backup file isn't the main data file (or master data file depending on who you ask) hence the file extension MDF. You can attach the MDF to the database by right clicking on the databases folder in Enterprise Manager (SQL 2000) or Management Studio (SQL 2005) then selecting all tasks and then Attach Database.
When you do this you will get an error about the log file missing. This shouldn't matter as SQL Server will simply create a new log file for you.
This will only work if the SQL Server was stopped when you copied the MDF file from the old SQL Server. If you copied the file while the SQL Server was running this file probably will not attach either and you will need to get a valid backup of the database.
Download help tool for sql database - SQL Server Restore Toolbox.
http://www.sqlserver.restoretools.com/
You can read up more on SQL Server here.
http://www.filerepairforum.com/forum/microsoft/microsoft-aa/sql-server/498-creating-a-new-database-using-an-mdf-file?_=1416149856104/

Nov 16, 2014 | Microsoft SQL Server 2000 Standard Edition...

5 Answers

How to recover deleted Microsoft SQL server MDF files?


Recover and repair MDF files with simple and efficetive tool to repair and recover MDF files from corrupt and damaged SQL server, which tool support all king of SQL server version and Windows OS. Visit here: http://www.en.mdfrepair.net
Read blog post: http://exchangerecovery.hubpages.com/hub/How-to-perform-SQL-Database-Recovery Corrupt MDF File Repair Utility

Apr 17, 2014 | Computers & Internet

2 Answers

How to convert SQl server 2005 to SQL server 2008


upgrade it or
take backup of your database
install sql server 2008
Restore backup in sql server 2008

Feb 05, 2011 | Office Equipment & Supplies

5 Answers

Need Help to backup SQL database in safe mode


kindly choose the option safe mode with networking and then try.

Sep 10, 2009 | Microsoft Computers & Internet

1 Answer

Symantec Backup Exec 11d compression


Unfortunately, the data types you described are already compressed.
Your hardware and software cannot compress it any further. In fact, compressing compressed files actually increases the file sizes. Don't worry, Backup Exec knows better than to compress compressed files so you can leave your settings in place.

The compressed capacity of a tape drive is a marketing ploy by the tape backup industry to make them more appealing. Yes, if your backup consisted entirely of uncompressed files you might get close to 75GB but never 80GB. You can only count on getting the uncompressed capacity of a tape.

Three options:
Obviously, a higher capacity tape drive will resolve this problem.
You could also swtich to using two tapes but you would have to load the second tape when you arrive for work in the morning and your backup would have to finish during the business day.
Finally, if you have some data that does not change frequently you could seperate it from your active data. Backup the active data on your regular backup. Now you can backup the "archived" data manually with a separate backup job. Once backed up you only have to back it up again when new data is added to the archive.

I hope this helps.

Jul 21, 2009 | Symantec VERITAS? Backup Exec 11 for...

1 Answer

Recovery


Before starting anything, get some information. Do you know:
  • What the files are called?
  • Where the files should be located?
  • What backup media you have a backup of the files on?

If you know the answer to the third question, then you can skip ahead. If you know which files need to be restored, but you don't know which media you need to restore from, you can either browse for the file, or use the Search Catalogs feature.
To browse for the file:
  1. Click Restore
  2. Ensure that in the View by box, Resource is selected
  3. Expand the server and resource where the files are located
  4. Browse through the media, folders and files to find the files you want
  5. Select the files and folders you wish to restore
To restore the files:
  1. Ensure you have the files you wish to restore selected
  2. If you wish to restore using a specific device, click Devices and choose the appropriate device
  3. If you wish to restore the files to a different location, click File Redirection, click the Redirect file sets box and choose where you want to restore to. If some of the files you wish to restore may be in use, then it may be a good idea to redirect the file set, then copy the files to the correct location
  4. Click General. If you want to restore the files from the backup media, even if they have been updated, then select Restore over existing files
  5. Click Run Now
  6. If the correct media is not already in the drive, you will be prompted to insert it.

Mar 27, 2009 | Symantec Backup Exec 10d for Windows...

4 Answers

How get sql data backup


there is facility in enterprise manager to take back of database!

Feb 04, 2009 | Keystone Active Server Pages (ASP)/Visual...

3 Answers

Hi...........


Well there is more than one or two answers 4 that.
you should first check if you are at simple recovery mode. If not (now this will sound strange) right click the database, click tasks/backup and make a LOG backup.
Now right click databases and click Restore Database.
You should choose a new database name (for restore practice) .
You will probably have your last backups at the bottom of the screen...if not click add and choose you latest data backup.
click the log backup and the data backup should be checked , too. on options tab make sure the database is left ready to use.

Oct 16, 2007 | Microsoft SQL Server Standard Edition for...

Not finding what you are looking for?
Microsoft SQL Server 2000 Standard Edition for PC Logo

463 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2642 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18375 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...