How do i backup a SQL server 2005 database through command prompt (Databases web development)

Answers

muschika

Mar 11, 2009 - 09:43 PM

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.

Report it

Comments (0) | New Comment

thiruhitech

Mar 18, 2009 - 05:31 AM

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

Report it

Comments (0) | New Comment

muschika

Mar 20, 2009 - 09:54 AM

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.

Report it

Comments (0) | New Comment

admin

Apr 11, 2009 - 12:19 PM

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

Report it

Comments (0) | New Comment