regarding restoring backup file taken from 32-bit operating system in 64-bit operating system

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Backups » regarding restoring backup file taken from...

regarding restoring backup file taken from 32-bit operating system in 64-bit operating system

Rate Topic

Display Mode

Topic Options

Author

Message

pandu.thota

Posted Tuesday, July 20, 2010 7:41 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, July 20, 2010 9:40 AM
Points: 1, Visits: 2

hi ,

i have a backup file which is taken from 32-bit operating system, 32- sql server 2008, now i want to retore the same to sql server 2008 but the operating system is 64-bit, (win 7 in both cases.).

but while restoring it is giving me error like invalid headers.

so can anyone tell whether can i meet my requirement (i.e restoring in 64-bit OS). if so what is the procedure.

thanks,
Satish.

Post #955560

Ray Mond

Posted Tuesday, July 20, 2010 9:51 AM

Old Hand

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 2:28 AM
Points: 343, Visits: 1,510

There isn't any extra steps required to restore a database created on a 32-bit SQL Server to a 64-bit SQL Server. Could you please post the entire result of your restore attempt?

Thanks.

Ray Mond

TLogInfo - the only FREE tool to analyse your transaction logs. Download here.
SQL BAK Reader - the only FREE tool to inspect your SQL Server backup files without using SQL Server. Download here.

Post #955717

prakskarry

Posted Thursday, July 22, 2010 11:23 PM

Valued Member

Group: General Forum Members
Last Login: Wednesday, September 26, 2012 9:03 PM
Points: 66, Visits: 161

First try to restore your backup on 32 bit OS only.It may be possible that the backup is curropt.

Post #957765

« Prev Topic | Next Topic »

Permissions