Database Backup And Recovery

Database restore

I'm struggling with when is the right time to do my last transactional log backup before my full database backup. My question is this: if I do a full db backup once a day at 10pm; and a tran log backup every 4 hours (12pm, 4am, 8am, 12am, 4pm, 8pm). If i have to restore the db to a point in...

Deleting Nightly Database Backups (dumps)

How do you set up a maintenance plan to delete or overwrite daily database backups (*.bak) file. My maintenance plan in SQL 2005 does not work...it doesn't do the cleanup it continuously appends to folder and I have to manually delete the files everyday

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

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)?

Backup database

Can I backup database with exception tables?

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

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...

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...