Quote:
Originally Posted by 18andLife
umm, i have sql2008r2, how can i back it up in 2005?
|
[Only registered and activated users can see links. Click Here To Register...]
1) Start convert wizard
Open SQL Server Management Studio2008. in 'Object Explorer', right click the database that you want to convert. Select 'Tasks' > 'Generate Scripts...'.
[Only registered and activated users can see links. Click Here To Register...] 2) Next
Click 'Next'.
[Only registered and activated users can see links. Click Here To Register...] 3) Select database and objects
Select the database that you want to convert, and check on '
Scripts all objects in the selected databases'
[Only registered and activated users can see links. Click Here To Register...] 4) Convert Options
Set options:
'Script for Server Version' = 'SQL Server 2005' 'Script Data' = 'True' 'Scirpt Database Create' = 'True'
[Only registered and activated users can see links. Click Here To Register...] 5) Output Option
Select option 'Script to file', 'Single file' and 'Unicode text'.
[Only registered and activated users can see links. Click Here To Register...] 6) 'Finish'
View summary and click 'Finish'.
[Only registered and activated users can see links. Click Here To Register...] 7) Result
Now you got a complete database creation script with data. It can be executed on target database server.
[Only registered and activated users can see links. Click Here To Register...]
8) Amend Script
Open the generated script in SQL Server Management Studio 2005. Find the following section and amend the path to proper data folder
PHP Code:
CREATE DATABASE [StockTraderDB] ON PRIMARY ( NAME = N'StockTraderDB', FILENAME = N'c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\StockTraderDB.mdf , SIZE = 4352KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) LOG ON ( NAME = N'StockTraderDB_log', FILENAME = N'c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\StockTraderDB_log.LDF', SIZE = 6272KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
9) Execute the Script
When finished, You should get converted database of SQL Server 2005