Re: Lost Data
- From: "Mike Epprecht \(SQL MVP\)" <mike@xxxxxxxxxxxx>
- Date: Tue, 20 Dec 2005 09:07:31 +0100
Hi
You probably have 2 backups in the single backup file.
Run
RESTORE HEADERONLY
FROM DISK="path and file name of your backup"
This will show you how many backups are in the file.
In Enterprise Manager, when you do the restore, you must make sure you
select the correct backup set that is listed on the screen.
Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@xxxxxxxxxxxx
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
<smounkhaty@xxxxxxxxxx> wrote in message
news:1135041110.154131.146250@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Hi Guru,
>
> This weekend, I migrated SQL Server7.0 to 2000 and below is the
> scenarios:
>
> 1.) At exactly 4:00PM on Sturday 17th, do full backup(T-SQL) and put a
> database into single user mode.
> 2.) Copy both Saturday 4PM and Friday night full dump to the SAN.
> 3.) Delete WinNT4.0.
> 4.) Reinstall Win2003 and service pack3a.
> 5.) Copy Saturday 4PM backup file to the server and do restore and do
> user ID mapping.
>
> This database is in full mode and I do log backup every hour. However,
> after restoring the database, any changes after the 14th were missing.
>
> Now, When I restored Friday night backup, we still recovered data to
> the 16th. My question is, why the 17th 4PM backup did not copy any
> change from 15th to the 17th Saturday?
>
> I still had Sturday backup file, howe can I recover the 17th data? Log
> explorer or ApexSQLLog?
>
> Is this Disk issue?
>
> Thanks very much,
> Silaphet,
>
.
- References:
- Lost Data
- From: smounkhaty
- Lost Data
- Prev by Date: Setting up SQL Server 2005 with SQL 200 and SQL 2005 Express
- Next by Date: Re: Installing SQL Server 2000 on Windows Small Business Server 2003?
- Previous by thread: Lost Data
- Next by thread: Setting up SQL Server 2005 with SQL 200 and SQL 2005 Express
- Index(es):
Relevant Pages
|
