it is possible to restore database from sql server 7, sql server 2000 to sql server 2005.
it can be achieved by using restore and with replace command
use master
restore database mydatabase from disk ='c:\mybackup.bak' with replace
skip to main |
skip to sidebar
About Iyen
- Iyen
- I am Iyen from coimbatore, India.There's nothing much to boast about me. As the name of the blog "Dynamic-Coding" suggests the blog carries about the stuff(Coding/Script) which we generally search in Internet.
Labels
- .NET (13)
- .NET 3.5 (1)
- ADO.NET (2)
- ASP.NET (8)
- Blogspot (1)
- C# (28)
- Crystal Report (1)
- Culture (1)
- Database Manipulation (1)
- Database Recovery (2)
- DataType (2)
- Email (1)
- Excel (2)
- Explorer (1)
- Fix/Solution (3)
- HTML (3)
- JavaScript (4)
- JavaScript-getElementById (2)
- LINQ to Objects (1)
- Macro (2)
- Memory Management (3)
- Multilingual (1)
- OOPS (9)
- PL/SQL (1)
- Satellite Assembly (1)
- Serilization (4)
- SMPT Client (1)
- SQL SERVER (12)
- SQL SERVER 2005 (7)
- Threading (1)
- VB.NET (1)
- VBA (2)
Blog Archive
-
▼
2009
(52)
-
▼
July
(18)
- PIVOT function in SQL Server 2005
- SQL Server 2005 - INTERSECT and EXCEPT operands.
- Step by Step procedure of CLR Integration in SQL S...
- XML Serialization in .NET
- SOAP Serialization in .NET
- ROLLUP in Sql Server
- Serial Number using ROW_NUMBER (Transact-SQL)
- Difference between MSDE and SQL Server Express 2005
- Database restore from SQL Server 7 ,SQL Server 200...
- Sql Server – Backup and Restore Database using SQL...
- Parameter types in C# (Value,out,ref and params)
- Serailization in .NET
- How to Fix cross mark in Crystal report while expo...
- How to Fix/Solution for Internet Explorer cannot o...
- How to Call Javascript function through CodeBehind...
- SQL Server 2000 Workload Governer
- Difference between MSDE and SQL Server 2000
- How to Filter Window Message in .NET
-
▼
July
(18)
1 comment:
Thanks, your solution solve my problems of restoring database seom sql server 2000 to 2005
Post a Comment