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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Is there a way to extend the server

Author  Topic 

lw1990
Yak Posting Veteran

85 Posts

Posted - 2010-03-24 : 17:59:08

I have a SQL Server 2005 server which is an Express version, and I have created some databases in the server. Now, I have an application(Sharepoint2007) connected to one database in the server, because it is Express version, I can not upload more than 4GB documents in the application.
The best way is to extend the database, but the Express version is limited to 4096 MB, I don’t know if there is a way to upgrade the server from Express version to Standard version.

Thanks.

Bustaz Kool
Master Smack Fu Yak Hacker

1834 Posts

Posted - 2010-03-24 : 18:14:18
I don't think that you can, if memory serves me right, but you can install SQL Standard as another instance and then move your databases to the new instance using either a backup/restore or detach/attach mechanism.

=======================================
There are no passengers on spaceship earth. We are all crew. -Marshall McLuhan, educator and philosopher (1911-1980)
Go to Top of Page
   

- Advertisement -