Running a local copy of SQL Server

88 Views Asked by At

Our company has a SQL Server 2008 R2 database on one of our servers. We would like to be able to make a copy of this database and open it off of a local machine; however, the size is greater than 10GB so the Express version won't do it. Is there a way we can open this locally without paying for another full license, since we do have one for running the database itself?

1

There are 1 best solutions below

1
On

There is no way to restore a DB over 4 gigs without a licence.

If we had more information about what you were trying to do with it, we might be able to suggest alternatives.

Is it for analysis? Perhaps you can come up with a SSIS package that copies over only the tables that you need.

Do you need it for backup? Perhaps there is another way to verify things.

Is it for testing? Well, you almost certainly need another licence in this case.