SQL Server 2008 Backup

[RPredrag]

Hello!

Is SQL Server 2008 backup on 64bit system possible to restore on Sql Server 2008 32bit. I think I read documentation that it is possible but earlier today I was getting error telling me that can not restore this is original error message I got.


TITLE: Microsoft SQL Server Management Studio
------------------------------

Restore failed for Server 'CAYMAN1'. (Microsoft.SqlServer.SmoExtended)

For help, click:

http://go.microsoft.com/fwlink?Prod...ceptionText&EvtID=Restore+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: Cannot open backup device 'F:\SQLBACKUP\NBABackup\NBA_backup_2010_02_01_013001_9161301.bak'. Operating system error 21(The device is not ready.). (Microsoft.SqlServer.Smo)

For help, click:

http://go.microsoft.com/fwlink?Prod...+((SQL_PreRelease).080709-1414+)&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

Any suggestion thanks in advance.

 

[gmmastros]

The database files are the same whether you use SQL server 64 bit or SQL Server 32 bit.

Cannot open backup device 'F:\SQLBACKUP\NBABackup\NBA_backup_2010_02_01_013001_9161301.bak'. [!]Operating system error 21(The device is not ready.)[/!]

There are several causes for this error. The most common causes are physical device failure. You may not have an F drive, the F drive may have bad sectors, or your bak file may be corrupt. I suggest you check these problems first.

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[mrdenny]

Make sure that you are referencing a drive on the server, not your computer.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog

 

[RPredrag]

Thanks a lot for both answers.

But issue was completely different. I still am not sure why error was pointing like backup cannot open device 'F:\SQLBACKUP\NBABackup\NBA_backup_2010_02_01_013001_9161301.bak' but after little more investigation I figure out that on my developer system I do not have enough hard disk space for backup to restore since log file was huge. After I shrink log file, restore worked just fine.