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 creat
e the database files...
Also, note that rebuildm has a bug where it can't run the source database fi
les 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 , Whi
le
> 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 use
r
> 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...
While[vbcol=seagreen]
can u[vbcol=seagreen]
user[vbcol=seagreen]
>|||Seems you are using the rebildm.exe program in a completely wrong way, I'm a
fraid. I recommend that
you start by reading in Books Online how this program work, no need to re-ph
rase all the information
from Books Online as you already have the information there. And then you ca
n 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 i
n
> message news:#$zD9pwwEHA.3824@.TK2MSFTNGP15.phx.gbl...
> create the database files...
> files from the CD, as it
> While
> can u
> user
>sql

No comments:

Post a Comment