[leana]

I have a large database size and I want to do Compact and repair database ,How?

i'm using Visual C# 2010 Express and SQL Server 2008

[nK0de]

to backup a database,

right-click on the database > Tasks > Back Up




to compress a database,

right-click on the database > Tasks > Shrink > choose whether you want to compress the database or the data files

[leana]

Is it possible to work through the code?
I want to do that from the program by using button, for example

[nK0de]

ooh haven't done that myself. In my workplace, there's this small program which we give to clients to take backups without interfering the backend SQL database. But unfortunately I don't have the code of that app. So I guess it's possible to create something like that. Sorry.

[leana]

Do you have any example that can help me ??
I found a lot of examples, but all about Access

[nK0de]

I just remembered the program which I mentioned earlier is written in VB6 or VB.NET. Since you're using C#, it won't be of any help either. and as I said I don't have access to the code of that. Sorry.

Try these tutorials.
http://www.codeproje...d-Restore-using

http://www.wisecodes...and-restore-it/

and here's an example

[leana]

nK0de, on 28 January 2012 - 12:16 PM, said:

I just remembered the program which I mentioned earlier is written in VB6 or VB.NET. Since you're using C#, it won't be of any help either. and as I said I don't have access to the code of that. Sorry.

Try these tutorials.
http://www.codeproje...d-Restore-using

http://www.wisecodes...and-restore-it/

and here's an example

thank you
There is no problem if the example c# or vb.net

[Atli]

* Moved to the C# forum *
This has less to do with the database at this point then it has to do with the code.