How can we startup our DB if any one redologs is corrupted totally 2 redologs
how can we startup our DB if any one redologs is corrupted totally 2 redologs.the corrupted redo is in archivemode.1st redo is corrupt tat is in current use of archive mode
Answer Question
| Oct 9 2008 6:21 AM GMT
| asked by
Kkvsaathish
Redo logs, Database backup and recovery, Database administration
backup and recovery
details about backup and recovery and suppose i was import data from oracle database. we can export to another database(not oracle)?
View Answer
| Sep 17 2008 11:27 AM GMT
| asked by
Onlyplsql
Oracle import/export, Backup & recovery, Database migration
Backup database
Can I backup database with exception tables?
View Answer
| Sep 3 2008 6:40 PM GMT
| asked by
Bjet
Backup storage, Database backup and recovery
SQL Query
I created a SQL query to restore several databases from a remote location to a test environment. I would like to add a check in the script so that it will not run if connected to certain servers so production databases are not accidentally overwritten
View Answer
| Jul 9 2008 6:34 PM GMT
| asked by
Asdemers
SQL Query, Scripting, Database backup and recovery
Setting database security to prevent restoring databases on other SQL Servers
Within a database in my SQL Server, I am able to control users from Alter Table and Alter SP, and a strong ‘sa’ password is also created. When I login to the backup of that database with a backup operator ID, the backup operator is able to restore the database, and his and others’ rights are...
View Answer
| Jul 2 2008 5:21 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server, Security, Database security
Backing up and restoring a LIVE database in SQL Server 2000
I am using SQL Server 2000, and I backup and restore my LIVE database to a new backup server every night. Do you have any ideas as to why my restored database runs slow when compared to the LIVE database? Do I need to rebuilding indexes? Is there any way of backing up indexes as part of the main...
View Answer
| Jul 2 2008 3:52 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server 2000, Indexes, Database backup and recovery
