SQL Server Backup recovery

Hi,

Is it possible to recover a sql incremential backup without disposing the full backup ?

Thank you for help

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.

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

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.

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