it is easy to take backup in sql server using script without any External tools.
By SIMPLE ways.. as follows...
use master
create database mydatabase
backup database mydatabase to disk ='c:\mybackup.bak'
Yeah,i can be easily restore by simple steps...
use master
restore database mydatabase from disk ='c:\mybackup.bak'
thats all..
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:
Today I opened my SQL Server and saw that it is working badly.But I remembered about software which can help in like situations-sql server data recovery.And utility helped me quite easy and free of charge.Moreover application showed me how it can help with this problem and retrieve the data, that was considered to be lost.
Post a Comment