| Topic : SQL Server Backup |
|
|
Database Administration
|
Activity:
Question posted: 04 25 2008 02:01:19 +0000,
5 answers, 183 views, last activity
07 06 2010 20:18:08 +0000
|
|
Expand Databases. Depending on the database, either select a user database or expand System Databases, and then select respective database. Right-click the database, point to Tasks, and then click Restore, then select from databse /from device either of the option depending upon the location where ur DB file is stored.In the Select the backup sets to restore grid, select the backups to restore and provide the location name where you want to restore... Let me know in case of any further doubts.
please Refer
http://msdn.microsoft.com/en-us/library/ms187510.aspx
http://msdn.microsoft.com/en-us/library/ms177429.aspx
This article covers the basics of full backup backups and restores in SQL Server. The examples are from SQL Server 2005 however it applies to SQL Server 2000 and SQL Server 2005. This is a very basic article covering full database backups, database restores and the simple and full recovery models.
This article covers the basics of full backup backups and restores in SQL Server. The examples are from SQL Server 2005 however it applies to SQL Server 2000 and SQL Server 2005. This is a very basic article covering full database backups, database restores and the simple and full recovery models.
Follow this :
After you connect to the appropriate instance of the Microsoft SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree.
Expand Databases. Depending on the database, either select a user database or expand System Databases, and then select a system database.
Right-click the database, point to Tasks, and then click Restore.
Click Database, which opens the Restore Database dialog box.
On the General page, the name of the restoring database appears in the To database list box. To create a new database, enter its name in the list box.
- Create a confidential Career Profile and Resume/C.V. online
- Get advice for planning their career and for marketing of experience and skills
- Maximize awareness of and access to the best career opportunities
|
|
Dynamic Management Views The dynamic management views (DMV’s) in SQL Server 2005 are designed... |
|
|
11 referals
6 comments,
1828 views
|
|
|
|
0 referals
3 answers,
351 views
|
|
|
Though media vs Self |
|
|
157 referals
105 arguments,
3039 views
|
|
|
|
|
|
|
|
|
I mean that it sector totally depends on outsourcing.But it might happen that in future other... |
|
|
0 referals
0 answers,
0 views
|
|
|
How Indian companies going to adopt this new technology.How cloud computing application going to... |
|
|
0 referals
0 answers,
0 views
|
|
|
|
Hello sir, My name is rakesh and I've completed my system management and networking from NIIT... |
|
|
1 referals
0 answers,
0 views
|
|
|
|
|
|
|
Great answer given by Mr.Ahmed.....agree with Markand and Aditya here...can't think of a better answer than this......too good...... |
I agree with Devi and others here that online shopping is secure and till date i have no problems with it and i mostly go for online because here one gets the best buys and some good discount too....and its hassel free one need not go to the store for... |
These financial conglomerate are continuing to bite each other and global slowdown have painted all the financial statement red. So, I think this is also affecting GE too. |