Select Categories Below
Advertisement
Start Your Own Q&A Site
Create your own Q&A site easily, allowing you to quickly grow a new community around any subject matter or generate new organic traffic for your existing website.
Status: Open Points: 125 Time: 15:51 - Jun 05, 2007
charel
I am trying to backup the database on sql2005, my current version of sql server 2005 evaluation has expired and not able to open it to backup the databases.. since these databases are important and need to be backed up i checked that it could be done via cmd prmopt but can someone guide me through the commands please
Categories:
Add Categories
When adding more than one category, separate them with commas.
muschika
Date:: Mar 12, 2009
Time:: 00:43
Since your evaluation has expired, you won't be able to use sqlcmd to back the database up either. You can however make a copy of the database files (.mdf) and (.ldf). With the two files, you will be able to attach the database to a SQL Server Express instance, which is a free download from Microsoft. Muschi.
thiruhitech
Date:: Mar 18, 2009
Time:: 08:31
hi muschi try this one start->programs->microsoft sql server 2005->sql server management studio-> after that in left side in object explorer-> database-> select your database and right click your database and choose task and then select backup option then save with .bak extension thanks
Date:: Mar 20, 2009
Time:: 12:54
hi thiruhtech, As you may tell from the original question, the sql server charel is using has expired, which means, he/she can not connect to the server using Management Studio. Consequently, the approach you suggested can not be used. Thanks.
admin
Date:: Apr 11, 2009
Time:: 15:19
The question looks to be abandoned by the user who asked it. If no action is taken within 2 days, a Quomon Moderator will consider closing the question and distributing the points. The Quomon Team
bailifei2011
Date:: Oct 23, 2011
Time:: 22:07
i googled a comparatively easier way to backup SQL: http://www.backup-sql-server.com/
Answer this Question
New User
Email:
Upon submission of this form, you will automatically be registered as a Quomon user and we will send your login information to this address
Registered User
Username:
Password:
Forgot Your Password?
Enter your email address below and we will resend your login information to you.
Login Information Sent
Questions
How do I restore a database on sql server through the command prompt?
You have 100 characters to use
Rank
Expert
Points
1.
10354
2.
6493
3.
5596
4.
4848
5.
3487
6.
2840
7.
2770
8.
2303
9.
1820
10.
917
Register today to share your knowledge with the community and be recognized and rewarded for your contributions.
Register Here
"Psst, Quomon is a great site. Pass it on." Tell a Friend | Link To Us | Save to Delicious | Digg it
Language Options
English:
Español:
Sponsors
Questions and Answers Software