• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 429
  • Last Modified:

SQL 2008 Back up failed

1) I tried to backup database 1 from a bak file from database 2, but failed.
database 1 is sql 2008 dev (bottom in attachment sqlvers)
database 2 is ql2008express (top in attachment sqlvers)

2) Why filename of backup is blank?
3) Error

Please advise.
Thanks.
sqlvers.jpg
sqlbacksource.jpg
sqlbkuperr.jpg
0
ksfok
Asked:
ksfok
2 Solutions
 
ProjectChampionCommented:
Instead of creating DB2 and then trying to restore it from DB1, just start with Restore (right click on the server and select restoe), then select the name of the new DB, add the backup set, and then proceed with the restore.
Also bear in mind the 4GB restriction for size in SQL Express.
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now