Can i created bak 2008 on sqlserver 2012?

Question

I created a database in sqlserver2012. I want created backup of it for use in sqlserver 2008.

It is possible to created Backup for use in sqlserver2008?

Erm, yes? Depends what the script is really, but it's quite likely that it **will** Where's the details! — SpaceBison, Mar 08 '13 at 08:12

score 1 · Accepted Answer · answered Mar 08 '13 at 14:21

Apologies in advance...I should have added this as a comment to one of the posts below.

If you are asking can you backup a SQL 2012 database and restore it to SQL 2008 (or any lower version for that matter), the answer is no. Scripting is going to be the only way to do this. Bear in mind that not all functionality in 2012 is going to be available in lower versions.

score 0 · Answer 2 · answered Mar 08 '13 at 08:13

0

The Tasks/Generate Script/Advanced dialog contains a dropdown to select the target SQL Server version to script for.

answered Mar 08 '13 at 08:13

devio

36,858
7
80
143

score 0 · Answer 3 · edited May 23 '17 at 10:25

0

Yes for sure you can, check this answer to know how to do it:

Generate script in SQL Server Management Studio

edited May 23 '17 at 10:25

Community

1
1

answered Mar 08 '13 at 08:17

Alex

5,971
11
42
80

Can i created bak 2008 on sqlserver 2012?

3 Answers3