Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
satya068
Posting Yak Master
233 Posts |
 Posted - 2010-03-23 : 05:36:49
|
| Hii...can i know how to increase the database size in sql 2005could i able to do this in databse properties?When iam copying the source database into destination ther is an error message'There is not enough diskspace in the destination server to copy the databse'could anyone plz help in the above query!thanksyashu |
|
|
ahmad.osama
Posting Yak Master
183 Posts |
Posted - 2010-03-23 : 06:16:10
|
quote:
Originally posted by satya068
Hii...can i know how to increase the database size in sql 2005could i able to do this in databse properties?When iam copying the source database into destination ther is an error message'There is not enough diskspace in the destination server to copy the databse'could anyone plz help in the above query!thanksyashu
free the space as said by the error message. The database size automatically increases as the data grows. y do u want to increase the size? |
 |
|
|
thewebhosting
Starting Member
17 Posts |
Posted - 2010-03-24 : 18:04:49
|
| Hi,If you have an admin access of MS SQL 2005 server then you can increase the database size from database properties section. Otherwise you have to contact your MS SQL database service provider to increase the database space. |
|
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2010-03-25 : 18:20:40
|
| Free some disk space as suggested by Ahmad. You can check database size and then check free space on drive where you will copy. |
|
|
|
|
|
|
Database size increase