You may think of having a mixture of Full, Differential and T-Log backups.

As per your scenario, having 1 FUll backup per night seems fine. I would recommend having Differential backups occuring...

You may create a Full Database Backup Job using Database Maintainence Planner using SQL EM.

Do not specify any name for the backup file. It will automatically create a new backup...

You cannot retrieve a single table from native SQL Server Database backup.

However, some of the backup-recovery tools provide this functionality.

SQL-Backtrack for SQL Server -- BMC Software.

This is a very good tool...

Try out the following steps.

You must be having jobs created for the Full and T-log backups in SQL EM.

Right click on T-Log backup job and "All Tasks" and Generate Script.

Save...

You can remove the Identity property of a column using SQL EM.

You can right click on a table and click Design Table. Point on the column on the table and select No...

Can you please explore more on your backup strategy ?

I mean what is the duration of the T-Log backups and when is it deleted ?

Also are your T-Log backups working...

Are u in the master database when you are executing your procedure. ?

I executed your procedure at my end. Its working perfect.

Just try with 'Use master' first and then exec...

"Delete statement conflicted with column reference constraint "FK_voucher_header_customers" the conflict occurred in database bayan,table voucher_header,column cust_no"

YOu have a foreign key constraint on that table from where you are going to...

The Backupset table in the msdb database contains information about the backup information specified when taking a backup.

select * from msdb..backupset where database_name like 'dbname'

The output contains a column called 'Description' which...

Kavitha --

I think this topic is getting rather very confusing.

I would reccomend you create a ONE New Backup Maintainence Plan for the Full and T-Log Backup.

Follow the exact steps...

Yes. YOu may check the FirstLsn and LastLsn of the backup files.

If the LastLsn of the first file matches the FirstLsn of the last file, then the two files are...

There is no exact method of association of Full and T-Log backups.

However you can try the following query in your msdb database.

select backup_start_date, backup_finish_date,database_name,type,first_family_number, last_family_number

from backupset where database_name like 'uscgdm_staging'

--Here...

What is the error you are getting ?

RESTORE DATABASE uscgdm_staging

     FROM DISK = '\\172.16.1.40\backups\USC\DATABASE BACKUPS\INCREMENTAL\uscgdm_staging_BACKUP_2005_WK10_DAY0.BAK'

     WITH NORECOVERY

Is this your Full Backup File ?

If yes, then just recover this...

Hi,

It should be working fine even with SQL EM. I have similar backup strategy wherein I take a Full Backup twice a day and T-Log backups every 15 mns.

Kavitha --...

Hi,

One more way of removing the duplicate records would be to dump the filtered data into a new table.

SELECT company_id,contact_type_id, contact_name into company_contacts

FROM company_contact

GROUP BY company_id, contact_type_id, contact_name

Then alter the new...