SQL Server Backup recovery
Hi,
Is it possible to recover a sql incremential backup without disposing the full backup ?
Thank you for help
Re: SQL Server Backup recovery
Take a backup
Launch SQL Server Management Studio (SSMS) and connect to your SQL Server instance.
Expand the Databases node in Object Explorer.
Right-click the database, hover over Tasks, and select Back up.
Under Destination, confirm the path for your backup is correct.
Select OK to take a backup of your database.
Re: SQL Server Backup recovery
Quote:
Originally Posted by
mikeduke1290
Take a backup
Launch SQL Server Management Studio (SSMS) and connect to your SQL Server instance.
Expand the Databases node in Object Explorer.
Right-click the database, hover over Tasks, and select Back up.
Under Destination, confirm the path for your backup is correct.
Select OK to take a backup of your database.
Hi,
I already try this method but it does not work, without the full Backup.
Regards
Re: SQL Server Backup recovery
Quote:
Originally Posted by
James West
Hi,
I already try this method but it does not work, without the full Backup.
Regards
The answer is no. An incremental backup requires a full back up as a starting point.
Not sure what you are trying to do, but read up on sql db snapshots. They can return the db to a known point in time and are seperate from backups.
Re: SQL Server Backup recovery
Quote:
Originally Posted by
Arjay
The answer is no. An incremental backup requires a full back up as a starting point.
Not sure what you are trying to do, but read up on sql db snapshots. They can return the db to a known point in time and are seperate from backups.
OK, I am going to check et will let you know the result