Question about Microsoft SQL Server 2000 Standard Edition for PC
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
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
Posted on Nov 19, 2014
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
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
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
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.
Posted on Jan 02, 2017
Tips for a great answer:
May 15, 2015 | Microsoft SQL Server 2008 Enterprise Full...
Apr 25, 2015 | Microsoft SQL Server 2005 Enterprise...
Feb 08, 2015 | Microsoft SQL Server 2000 Standard Edition...
Nov 16, 2014 | Microsoft SQL Server 2000 Standard Edition...
Apr 17, 2014 | Computers & Internet
Jul 21, 2009 | Symantec VERITAS? Backup Exec 11 for...
Mar 06, 2009 | Microsoft SQL Server 2005 Standard Edition
Oct 16, 2007 | Microsoft SQL Server Standard Edition for...
Jul 24, 2012 | Microsoft SQL Server 2000 Standard Edition...
462 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: