How To Generate Database Backup Script In SQL 2008 R2
In some cases Microsoft SQL database .bak file will not restored and due to the versions difference.In this case developer prefer to generate backup script file.Here is the steps to generate script backup file.
– Log in to server with administrator account.
– Now expand the databases.
– In next window click Advanced tab.
– In Advanced Scripting Options change Types of data to script is Schema and data.
– And Change Script Data Compression Options is True.
Tags:Ms-SQl,SQl Scripts,SQl 2008,SQl 2008 R2,SQl backup,SQl 200 R2 installation.