-
October 8th, 2020, 10:12 AM
#1
SQL Server Backup recovery
Hi,
Is it possible to recover a sql incremential backup without disposing the full backup ?
Thank you for help
-
October 9th, 2020, 07:08 AM
#2
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.
-
October 9th, 2020, 07:57 AM
#3
Re: SQL Server Backup recovery
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
-
October 9th, 2020, 08:56 AM
#4
Re: SQL Server Backup recovery
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.
-
October 9th, 2020, 09:18 AM
#5
Re: SQL Server Backup recovery
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
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|