LateNightDBA


When restoring a database where the data file(s) are located under a mount point, seems to be a problem with reporting free space available.

DB Size - Say 30GB (25 Data, 5 Log)

E:\ Drive 20GB with 15GB Free

Restoring database file to

E:\SQLMountPoint\

- This points to separate disk with more than enough free space

SQL prevents the restore by stating there is not enough free space.

A long work around is

assign a drive letter to the large disk

Restore database using temp drive letter - F:\SQLDATA\MyDB_Data.mdf

Update sysfiles - changing drive & path - E:\SQLMountPoint\SQLDATA\MyDB_Data.mdf

Stop & restart database...

Is there a better way

Wishlist - Restore only warns about free space - but allows continue...

Regards




Re: Recovery of database on a mount point

WesleyB


Which OS version and SQL Server version are you using

WesleyB

Visit my SQL Server weblog @ http://dis4ea.blogspot.com






Re: Recovery of database on a mount point

LateNightDBA

Thanks for the reply.

OS: Windows2003 x64 Datacenter R2

SQL: Now running 9.00.3175 - seems to have resolved the problem

- unable to find mention in fixlists

More testing required just to be sure.

LateNightDBA...






Re: Recovery of database on a mount point

WesleyB

You will typically not find every fix in the published fix list.

I'm glad it works now.

WesleyB

Visit my SQL Server weblog @ http://dis4ea.blogspot.com