all groups > sql server data warehouse > october 2004 >
You're in the

sql server data warehouse

group:

Recover data from yesterday


Recover data from yesterday Alain
10/7/2004 12:02:23 PM
sql server data warehouse: 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.

Re: Recover data from yesterday Wayne Snyder
10/13/2004 8:34:40 AM
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

[quoted text, click to view]

AddThis Social Bookmark Button