- Select your source Database
- Select Tasks -> Generate Scripts.
- Select 'Script entire database and all database objects', -> press 'Next'
- Select 'Save to File' and -> click on the 'Advanced' button
- Select 'Script for Server Version' and -> select the version you want: 200/2005/2008
- Select 'Type of data to Script' and -> select Schema/Data/both
- Click 'OK',Next and do it!
21 August 2013
How to Backup SQL Server 2008 R2 Restore on SQL 2008
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment