8 Replies - 2208 Views - Last Post: 16 July 2013 - 05:53 AM Rate Topic: -----

#1 leana  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 11
  • Joined: 23-January 12

How can Backup and Compression database (SQL Server 2008)?

Posted 28 January 2012 - 11:00 AM

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
Is This A Good Question/Topic? 0
  • +

Replies To: How can Backup and Compression database (SQL Server 2008)?

#2 nK0de  Icon User is offline

  • Catch me As Exception
  • member icon

Reputation: 204
  • View blog
  • Posts: 823
  • Joined: 21-December 11

Re: How can Backup and Compression database (SQL Server 2008)?

Posted 28 January 2012 - 11:10 AM

to backup a database,

right-click on the database > Tasks > Back Up

Posted Image


to compress a database,

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

Posted Image
Was This Post Helpful? 1
  • +
  • -

#3 leana  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 11
  • Joined: 23-January 12

Re: How can Backup and Compression database (SQL Server 2008)?

Posted 28 January 2012 - 11:20 AM

Is it possible to work through the code? :smile2:
I want to do that from the program by using button, for example
Was This Post Helpful? 0
  • +
  • -

#4 nK0de  Icon User is offline

  • Catch me As Exception
  • member icon

Reputation: 204
  • View blog
  • Posts: 823
  • Joined: 21-December 11

Re: How can Backup and Compression database (SQL Server 2008)?

Posted 28 January 2012 - 11:28 AM

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.
Was This Post Helpful? 0
  • +
  • -

#5 leana  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 11
  • Joined: 23-January 12

Re: How can Backup and Compression database (SQL Server 2008)?

Posted 28 January 2012 - 11:41 AM

Do you have any example that can help me ?? :)
I found a lot of examples, but all about Access :(
Was This Post Helpful? 0
  • +
  • -

#6 nK0de  Icon User is offline

  • Catch me As Exception
  • member icon

Reputation: 204
  • View blog
  • Posts: 823
  • Joined: 21-December 11

Re: How can Backup and Compression database (SQL Server 2008)?

Posted 28 January 2012 - 12:16 PM

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
Was This Post Helpful? 0
  • +
  • -

#7 leana  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 11
  • Joined: 23-January 12

Re: How can Backup and Compression database (SQL Server 2008)?

Posted 28 January 2012 - 12:29 PM

View PostnK0de, 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
Was This Post Helpful? 0
  • +
  • -

#8 Atli  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 3712
  • View blog
  • Posts: 5,964
  • Joined: 08-June 10

Re: How can Backup and Compression database (SQL Server 2008)?

Posted 29 January 2012 - 06:59 AM

* Moved to the C# forum *
This has less to do with the database at this point then it has to do with the code.
Was This Post Helpful? 0
  • +
  • -

#9 VARUN NAYAK  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 16-July 13

Re: How can Backup and Compression database (SQL Server 2008)?

Posted 16 July 2013 - 05:53 AM

Check Below link, may be it will help you

http://www.geekpedia...-databases.html
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1