Restoring backups between SQL Server 2005 Editions
-
Hi Guys, Is it possible to restore a backup of SQL Server 2005 Enterprise/Standard Edition onto a SQL Server 2005 Express Edition DB. I have a small backup file. its really small. Can someone just restore the backup for me and generate an SQL script from it. I need the script. I'll be lost without it. Thanks in advance everyone.
-
Hi Guys, Is it possible to restore a backup of SQL Server 2005 Enterprise/Standard Edition onto a SQL Server 2005 Express Edition DB. I have a small backup file. its really small. Can someone just restore the backup for me and generate an SQL script from it. I need the script. I'll be lost without it. Thanks in advance everyone.
Mridang Agarwal wrote:
Is it possible to restore a backup of SQL Server 2005 Enterprise/Standard Edition onto a SQL Server 2005 Express Edition DB.
I've never done this myself, but I'm almost 100% sure that it is possible.
Mridang Agarwal wrote:
I have a small backup file. its really small. Can someone just restore the backup for me and generate an SQL script from it. I need the script.
Can you restore a backup using a SQL Server Management Studio? If yes, you can generate an appropriate script automatically in SSMS. (Of course I could paste you the script here right away, but if you do it yourself you'll learn more.)