SQL Server - Backup chain status if a backup is stop halfway
Asked By wodoy.peter
08-Oct-09 06:13 AM
Hi,
Considering this backup plan:
- Sunday: Full backup
- Mon - Sat: Differential backup
Says, on Wednesday, the backup is running half way, it was then
cancelled manually (SSMS > SQL Server Agent > Jobs > Right click on
the backup job > Click "Stop job").
crashed on Friday and required restore, what is the latest restore date
I could get to? Tuesday or Thursday?
Thanks in advance.
Peter C.
SQL Server
(1)
Backup
(1)
Date
(1)
Database
(1)
Wednesday
(1)
Thursday
(1)
Tuesday
(1)
Friday
(1)
Tom Cooper replied...
Stopping a backup does not break the backup chain.
Differential backups contain all the changes since the last successful full
backup. So restoring the full backup from Sunday and then the differential
backup from Thursday will recover your database no matter what happened to
Wednesday's backup.
Tom
MSDE on Windows 2003 R2 box, new DL385G6 - Install Fails during SQL Services SQL Server I have been finding that I am having trouble with the Crystal Reports Server XI installation failing when it is dealing with SQL. So, as a thought and in case there was something wrong with my SQL portion of the isntall. I thought ok, I will try installing the actual MSDE application direct from Microsoft. So, I downloaded the MSDE for SQL 2000 (which is msde2000a.exe), set my switches and off to the races. It quit seconds left to the installation and bombed with the same errors as the Crystal Reports Server install. The error is the same whether I try to install MSDE by itself or
Why_can’t_recursive_queries_contain. . .? SQL Server hi I hope I didn = 92t put too many questions 1) Why can = 92t recursive queries also be unioned together with UNION operator ( instead they must use UNION ALL )? thanx SQL Server Programming Discussions SQL Server 2008 (1) SQL Server 2005 (1) SQL Server 2000 (1) SQL Server (1) Oracle (1) Ruby (1) MichaelcoAToptonlineDOTnet (1
SQL Express: Failed Reinstall SQL Server Dear Setup Experts: I am trying to reinstall SQL Express after playing with it some. I uninstalled it, and now, it refuses to reinstall in the face. Any ideas what this log file means and how I can get SQL Express installed? I really do not want to have to reinstall my whole system. * ** ** Start of Log File Overall summary: Final result: SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup. Exit code (Decimal): -2068643839 Exit facility code: 1203
Sql Remote Connection issue SQL Server I am trying to setup Sql Server 2000 to handle remote connections from the web. I have setup the firewall to allow port 1433 to be redirected back to the internal Sql Server which I know is working. To verify the connection I am using telnet to verify 1433: Connect Failed Any ideas or solutions to the above problem would be greatly appreciated. SQL Server Connect Discussions SQL Server 2005 (1) SQL Express (1) SQL Server (1) Windows XP
Bulk Insert Help SQL Server Hi Guys, Just trying to complete a Bulk Insert and am getting an error: Incorrect quotes and column delimiter of coma. Can anyone advise how I can correct this. Thanks SQL Server New Users Discussions SQL Server 2005 (1) SQL Server 2000 (1) SQL Server (1) CREATE TABLE (1) Exception (1) NOT NULL (1) Nvarchar (1