Monday, March 26, 2012

rebuilt option for master database

I was testing Disaster Recovery plann for master database recovery , While
rebuliding master file on test setup , I am getting following error , can u
pls let me know why does it give this error ..I am already in a single user
mode .
Rebuilt master is failed due to following error no : 266 , copy function
cannot be used
There has been sharing violations in source or destination file .
Regards,
swatiSeems like your SQL Server is still started so that rebuildm.exe can't create the database files...
Also, note that rebuildm has a bug where it can't run the source database files from the CD, as it
doesn't remove the read-only attribute.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"swati" <swati.zingade@.ugamsolutions.com> wrote in message
news:%23gE5zkwwEHA.3528@.TK2MSFTNGP10.phx.gbl...
> I was testing Disaster Recovery plann for master database recovery , While
> rebuliding master file on test setup , I am getting following error , can u
> pls let me know why does it give this error ..I am already in a single user
> mode .
> Rebuilt master is failed due to following error no : 266 , copy function
> cannot be used
> There has been sharing violations in source or destination file .
>
> Regards,
> swati
>
>|||Hi !
sql server is in single user mode , and then i tried to rebulid the same
using rebuild option ,i am accessing the files which are present in
c:\programme files \ ..ie. a default directory . there is no read only
option for data /log files . Pls tell me what should be done ?
Regards,
Swati
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:#$zD9pwwEHA.3824@.TK2MSFTNGP15.phx.gbl...
> Seems like your SQL Server is still started so that rebuildm.exe can't
create the database files...
> Also, note that rebuildm has a bug where it can't run the source database
files from the CD, as it
> doesn't remove the read-only attribute.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "swati" <swati.zingade@.ugamsolutions.com> wrote in message
> news:%23gE5zkwwEHA.3528@.TK2MSFTNGP10.phx.gbl...
> > I was testing Disaster Recovery plann for master database recovery ,
While
> > rebuliding master file on test setup , I am getting following error ,
can u
> > pls let me know why does it give this error ..I am already in a single
user
> > mode .
> >
> > Rebuilt master is failed due to following error no : 266 , copy function
> > cannot be used
> > There has been sharing violations in source or destination file .
> >
> >
> > Regards,
> > swati
> >
> >
> >
>|||Seems you are using the rebildm.exe program in a completely wrong way, I'm afraid. I recommend that
you start by reading in Books Online how this program work, no need to re-phrase all the information
from Books Online as you already have the information there. And then you can of course post back
questions here is you still don't get it working.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"swati" <swati.zingade@.ugamsolutions.com> wrote in message
news:OaroX0wwEHA.2572@.tk2msftngp13.phx.gbl...
> Hi !
> sql server is in single user mode , and then i tried to rebulid the same
> using rebuild option ,i am accessing the files which are present in
> c:\programme files \ ..ie. a default directory . there is no read only
> option for data /log files . Pls tell me what should be done ?
>
> Regards,
> Swati
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:#$zD9pwwEHA.3824@.TK2MSFTNGP15.phx.gbl...
> > Seems like your SQL Server is still started so that rebuildm.exe can't
> create the database files...
> >
> > Also, note that rebuildm has a bug where it can't run the source database
> files from the CD, as it
> > doesn't remove the read-only attribute.
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > "swati" <swati.zingade@.ugamsolutions.com> wrote in message
> > news:%23gE5zkwwEHA.3528@.TK2MSFTNGP10.phx.gbl...
> > > I was testing Disaster Recovery plann for master database recovery ,
> While
> > > rebuliding master file on test setup , I am getting following error ,
> can u
> > > pls let me know why does it give this error ..I am already in a single
> user
> > > mode .
> > >
> > > Rebuilt master is failed due to following error no : 266 , copy function
> > > cannot be used
> > > There has been sharing violations in source or destination file .
> > >
> > >
> > > Regards,
> > > swati
> > >
> > >
> > >
> >
> >
>

No comments:

Post a Comment