Solid State Disks and SQL Server

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Wesley Brown » Solid State Disks and SQL Server

61 posts, Page 7 of 7

«««3 4 5 6 7

Solid State Disks and SQL Server

Rate Topic

Display Mode

Topic Options

Author

Message

DenisT

Posted Monday, October 08, 2012 12:44 PM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 3:23 PM
Points: 24, Visits: 187

Hi Wesley,

Thank you for the info! I understand that it has been a while since you wrote this article but I hope you could answer my questions.

My company just bought ioDrive 2.0 and I've been playing with it.

You wrote:
"... Also, having to convert all my databases from a 512 byte block to a 4KB block is a road block. There is no other way to do this other than copy all the data to a new database that is created on the new 4KB sector size. ..."

Does it mean that a simple restore should do the job? The backup is taken on a drive that is formatted with 512 byte sectors. If I format ioDrive 2.0 to 4K sectors and restore the backup on it, it should be just fine, right?

Thanks,
Denis

Post #1369997

« Prev Topic | Next Topic »

61 posts, Page 7 of 7

«««3 4 5 6 7

Permissions