Friday, March 9, 2012

Recover data from yesterday

Hi,
I'm not a database manager,
I have to recover the old database instead of the actual.
I backed up the old one from a tape backup.
Do i have just to rename the existing one and copy the one
that i want in the same folder.
People told me that there was no change between these two
version except that someone erase a folder.
Thank...
If you are talking about SQL Database (instead of MDMArch'd Analysis
Services database) ,YOu may restore the SQL database using the restore
wizard, but
1. Restore as a DIFFERENT database name and
2. on the second tab, choose DIFFERENT PHYSICAL FILENAMES/Locations for
each file so you will not overwrite the good, current version of the
database...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Alain" <anonymous@.discussions.microsoft.com> wrote in message
news:233501c4aca0$2e00dd90$a601280a@.phx.gbl...
> Hi,
> I'm not a database manager,
> I have to recover the old database instead of the actual.
> I backed up the old one from a tape backup.
> Do i have just to rename the existing one and copy the one
> that i want in the same folder.
> People told me that there was no change between these two
> version except that someone erase a folder.
> Thank...

No comments:

Post a Comment