Pages
Labels
- Bisnis (1)
- CIT Scripts - Financore (5)
- Cokelat (3)
- MySQL (2)
- PHP (23)
- PT Comment Indonesia (10)
- SQL Query (2)
- SQL Server 2000 (4)
- SQL Server 2005 (4)
- Tips - Tricks Cokelat (2)
Archives
Link List
- Code Igniter Indonesia
- MySQL Reference Manuals
- MySQL Tutorial
- SQL Developer
- 9 Useful jQuery Calendar and Date Picker Plugins For Web Designers
- 10 Powerful AJAZ jQuery File Uploaders
- 35 Useful jQuery Plugins for Slideshows, Graphs and Text Effects
- 30 jQuery Calendar Date Picker Plugins
- jQuery
- Web Developers Notes
- SQL Copy MySQL Table
- Natural Cooking Club Indonesia
- Aneka Resep Praline - Sedap Sekejap
- Resep Cokelat
- Pastry and Bakery
- Peluang Bisnis Hotspot
- Billing Hospot
- JpGraph
- Zend Developer Zone
- MySQL Tutorials and Others
- W3 School
- Open Source Projects
RESTORE FILELISTONLY FROM DISK = ‘E:\DB\PF31Des2007.bak’
RESTORE DATABASE PF31Des2007
FROM DISK = ‘E:\DB\PF31Des2007.bak’ WITHREPLACE,
STATS = 10,
MOVE ‘CSF_Data’ TO ‘E:\Database\PF31Des2007_Data.mdf’,
MOVE ‘CSF_Index’ TO ‘E:\Database\PF31Des2007_1.mdf’,
MOVE ‘CSF_Log’ TO ‘E:\Database\PF31Des2007_log.ldf’
GO
RESTORE DATABASE PF31Des2007 RECOVERY
RESTORE DATABASE PF31Des2007
FROM DISK = ‘E:\DB\PF31Des2007.bak’ WITHREPLACE,
STATS = 10,
MOVE ‘CSF_Data’ TO ‘E:\Database\PF31Des2007_Data.mdf’,
MOVE ‘CSF_Index’ TO ‘E:\Database\PF31Des2007_1.mdf’,
MOVE ‘CSF_Log’ TO ‘E:\Database\PF31Des2007_log.ldf’
GO
RESTORE DATABASE PF31Des2007 RECOVERY
GO
Labels: SQL Server 2000
0 Comments:
Subscribe to:
Post Comments (Atom)
