Hibernate Community • View topic - Sql Server Filegroup support

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

Sql Server Filegroup support

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

cybereg

Post subject: Sql Server Filegroup support

Posted: Sun Aug 08, 2010 1:33 am

Newbie

Joined: Sun Aug 08, 2010 1:08 am
Posts: 2

Hi,

I'm working with NHibernate 2.1, NHibernate.Mapping.Attributes and
NHibernate.Tool.hbm2ddl.SchemaExport to generate the sql scripts for the Sql Server 2008.
For performance issues i want to put all indices in a additional filegroup.

Is there any possibility to parameterize NHibernate for this demand?

tia cybereg

Top

cybereg

Post subject: Re: Sql Server Filegroup support

Posted: Fri Aug 27, 2010 8:53 am

Newbie

Joined: Sun Aug 08, 2010 1:08 am
Posts: 2

A workaround, for finishing the generated sql script manualy with the help of regular expressions:

Code:

private static string ReplaceIndexFileGroup(string input)
{
    const string pattern = @"(?<start>create\s+index\s+\w+\s+on\s+\w+\s+\(\w+(?<field>,\s+\w+)*\))(?<end>;)";

    const string replacement = "${start} on Indices;";
            
    var rgx = new Regex(pattern);
    var result = rgx.Replace(input, replacement);
            
    return result;
}

hth cybereg

Top

lee82

Post subject: Re: Sql Server Filegroup support

Posted: Tue Aug 31, 2010 3:06 am

Newbie

Joined: Tue Aug 31, 2010 1:43 am
Posts: 1

Hi,

It is not possible to stop the recovery of individual files early. For this reason, you must always back up the active transaction log prior to restoring a file backup. If the transaction log is damaged or if you wish to recover the entire database to a specific point in time, you must restore the entire set of file backups before you apply transaction log backups. To minimize the risk of transaction log damage, locate the transaction log on fault tolerant storage.

Wordpress Newsletter Plugin

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum