Home » Computer Associates » Computer Software » Computer Associates SQLSTQ99000600

Get support for Computer Associates SQLSTQ99000600 - Unicenter SQL-Station 6.0.0

Computer Associates SQLSTQ99000600 Support Question

Find answers below for this question about Computer Associates SQLSTQ99000600 - Unicenter SQL-Station 6.0.0.
Need a Computer Associates SQLSTQ99000600 manual? We have 2 online manuals for this item!

Computer Associates Overview Questions Manuals Reviews Videos Research

Question posted by silasperkins on March 15th, 2016

Operational Db Without An .ldf File And No Useful Backups On Sql Server 2005.

No, the question isn't stupid but the "admin" sure is.... BUT, if you can help, please do! The problem is how to recover a .mdf file into an operational db without an .ldf file and no useful backups on SQL Server 2005. See, I told you - STUPID!! Now, I've seen plenty of suggestions for SQL 2K, but not 2005. Single file attach - no go. Detach wasn't proper. DBCC REBUILD_LOG, where most SQL 2K solutions end up - can't get there on 2005. At least not in any method I've tried. Access to those system tables not allowed (no "ad-hoc queries"). 3rd party recovery tools? Anything....? (This isn't a big db, ~ 8GB, but it is rather important AND urgent). Many thanks!

I Know the Answer!

I have the same question
Request More Information

Current Answers

Answer #1: Posted by OrnSveinsson on March 23rd, 2016 7:20 AM

This answer was accepted by the poster of the original question.

OrnSveinsson

Member since:
March 21st, 2016

Points: 1,120

1,110
points

You will have data loss but it can be done.

1) Detach database and move your mdf to save location.
2) Create new databse of same name, same files, same file location and same file size.
3) Stop SQL server.
4) Swap mdf file of just created DB to your save one.
5) Start SQL. DB will go suspect.
6) ALTER DATABSE <your db> SET EMERGENCY
ALTER DATABASE <your db> SET SINGLE_USER
7) DBCC CHECKDB (<your db>, REPAIR_ALLOW_DATA_LOSS)
8) ALTER DATABASE <your db> SET MULTI_USER
ALTER DATABSE <your db> SET ONLINE

From programs you can try SQL Server Recovery Toolbox if you want. There is a demo version, so you can check it will help you or not. http://www.oemailrecovery.com/sql_repair.html

Answer #2: Posted by OrnSveinsson on March 23rd, 2016 7:23 AM

OrnSveinsson

Member since:
March 21st, 2016

Points: 1,120

110
points

May be this article will give you more information.

http://www.techrepublic.com/forums/questions/it-seems-our-sql-database-is-corrupted/

Related Computer Associates SQLSTQ99000600 Manual Pages

Microsoft SQL Guide - Page 8

... Torn Page Restore Using Microsoft SQL Server 2005 or 2008 68 Perform an Online Torn Page Restore Using Microsoft SQL Server 2005 or 2008 Enterprise, Data Center, or Developer Editions 70 Chapter 5: Backing Up and Restoring in Cluster Environments 73 Backup and Restore Considerations in Microsoft SQL Server Cluster Environments 73 Microsoft SQL Server 2000, 2005 and 2008 Cluster Environment...

Microsoft SQL Guide - Page 34

..., or selected set the database subset to Files and FileGroups for a database overrides the selection in the same job. You can use this option to back up a file or FileGroup when the database size and performance requirements make it impractical to back up . This option requires SQL Server 2005 or later. ■ Back up Transaction Log...

Microsoft SQL Guide - Page 45

...or Developer Editions (see page 70) Chapter 4: Restoring Microsoft SQL Server Databases 45 Chapter 4: Restoring Microsoft SQL Server Databases This section contains information about restoring databases and Transaction logs using CA ARCserve Backup, the Agent for Microsoft SQL Server, and Microsoft SQL Server 7.0, Microsoft SQL Server 2000, Microsoft SQL Server 2005 and Microsoft SQL Server 2008.

Microsoft SQL Guide - Page 49

... performed after the last file or FileGroup operation. For more information about restoring to a different location, see Restore to isolate the damaged parts of CA ARCserve Backup or BrightStor® Enterprise Backup. Restore Options Files and FileGroups restore Restores selected files and FileGroups. SQL Server 2005 has the ability to Alternative Disk Locations Using Automatic Selection...

Microsoft SQL Guide - Page 52

... physical and logical consistency of the database. (SQL Server 2005 or later, Enterprise Edition only.) Do not check indexes Checks the database for consistency without using Automatic Selection. The database is brought online in the restore options. You must be revered to make this option. 52 Agent for backup, the standby database will fail. Leave...

Microsoft SQL Guide - Page 53

.... Miscellaneous The following are recorded in the Agent for database restore and file or FileGroup restore operations. Selecting this option for Microsoft SQL Server log file called sqlpagw.log. The log is restoring. Microsoft SQL Server 2005 will refuse by performing a Log Tail backup, or restore with the "WITH REPLACE" option. Instead, it produces an error message saying...

Microsoft SQL Guide - Page 54

...members of the database which it restores a database or log backup on a warm standby server and recovers the database. In Microsoft SQL Server 2000 and Microsoft SQL Server 2005, Restricted_User replaces the DBO_Only option from Microsoft SQL Server 7.0. You cannot select this option only with the Leave database non-operational, but able to restore additional transaction logs option.

Microsoft SQL Guide - Page 60

..., perform the following procedure: a. c. Expand the media containing the backup you want to restore the sessions of Microsoft SQL Server. Restore Databases Using Restore by Session Method Restore Databases Using Restore by Session Method To perform a restore operation using Microsoft SQL Server 2000 or Microsoft SQL Server 2005, you can also enter a machine name, instance name, and...

Microsoft SQL Guide - Page 68

.... Click OK. i. Perform an Offline Torn Page Restore Using Microsoft SQL Server 2005 or 2008 Perform an Offline Torn Page Restore Using Microsoft SQL Server 2005 or 2008 Microsoft SQL Server 2005 and 2008 have not performed step 2 separately, you should also select the Database Consistency Check Before Backup option and Continue Backup if DBCC Fails option. 5. In addition to torn page...

Microsoft SQL Guide - Page 69

Resume use of the database. Submit the Restore job. 6. Chapter 4: Restoring Microsoft SQL Server Databases 69 Change to Simple Recovery Model, if you changed the Recovery Model in step 1. 7. Perform an Offline Torn Page Restore Using Microsoft SQL Server 2005 or 2008 j.

Microsoft SQL Guide - Page 70

... Enterprise, Data Center, or Developer Editions 1. k. Perform an Online Torn Page Restore Using Microsoft SQL Server 2005 or 2008 Enterprise, Data Center, or Developer Editions Perform an Online Torn Page Restore Using Microsoft SQL Server 2005 or 2008 Enterprise, Data Center, or Developer Editions Microsoft SQL Server 2005 and 2008 have the ability to detect when the data in the [suspect_pages...

Microsoft SQL Guide - Page 71

...damaged page. 5. Chapter 4: Restoring Microsoft SQL Server Databases 71 Perform a Transaction Log backup with the Recovery Completion State set to Leave Database operational. 7. Resume use of this final Transaction Log backup without Automatic Selection, and with the default options. 6. Perform an Online Torn Page Restore Using Microsoft SQL Server 2005 or 2008 Enterprise, Data Center, or...

Microsoft SQL Guide - Page 111

... data files. ■ If you are using Microsoft SQL Server 2005 or later, you can partition tables across multiple FileGroups to exclude Read-only FileGroups from tables with less expected traffic by multiple read/write devices. ■ Put different tables used . If a database is static but needed for more details. ■ Consider data stability to help you...

Microsoft SQL Guide - Page 113

... File and FileGroup (requires SQL Server 2000 or later) Not Available Partial Database Optional (Requires SQL Server 2005 or later) Backup Transaction Log After Database Full Required Optional Required Optional Optional Optional Bulk-Logged Required Optional Required Optional Optional Optional Appendix C: Backup and Recovery Best Practices 113 Allows your databases can recover...

Microsoft SQL Guide - Page 114

... objects such as a replication distributor. Resource Database (SQL Server 2005 or later) The Resource Database is not mounted as the replication database. It is read-only. System Databases You can use CA ARCserve Backup to as a live database, so the files are exempt from the Global or Rotation Job backup method. The three main system databases (master...

Microsoft SQL Guide - Page 122

... Microsoft SQL Server Guide Also, you back up . Backup Concepts How the Create Index Statement Impacts File and FileGroup Backups The Backup statement requires that you can perform a Partial Restore from a Partial Backup, provided all of the desired FileGroups are contained within the Partial Backup session. Partial Backups Microsoft SQL Server 2005 introduces a special type of Files-and...

Microsoft SQL Guide - Page 123

...Full backup. Use CA ARCserve Backup and the Agent for the backup used in when the Backup statement for Microsoft SQL Server to perform restore operations using the Simple Recovery Model, you cannot perform a Database Differential backup after a Database Differential backup, the Partial Full backup will be between it does to create a database. If you mix Files and FileGroup backups...

Microsoft SQL Guide - Page 124

If a failure occurs while a database is using the Microsoft SQL Server Enterprise Manager or Management Studio. If the database is not relevant for Microsoft SQL Server Guide By default, Microsoft SQL Server 2005 will not allow the restore operation. Note: If you cancel a restore job, the database may be left in a loading state and will not allow a restore to start...

Microsoft SQL Guide - Page 129

.... When this operation. ■ Online -- The database remains online and undamaged tables are similar to isolate damaged parts of data on disk marked as damaged. Use the more information, see Note 1 (see page 130). SQL Server 2005 and later have the ability to those for a Torn Page repair, which is performed. Partial Full Backup None For...

Microsoft SQL Guide - Page 136

...Page Restore Using Microsoft SQL Server 2005 or 2008 • 68 Perform an Online Torn Page Restore Using Microsoft SQL Server 2005 or 2008 Enterprise, Data Center, or Developer Editions • 70 Perform Disaster Recovery in Microsoft SQL Server 2000, 2005, or 2008 Cluster Environments • 83 Performance Improvement Tips • 111 post-installation procedures configuring backup and restore...