Real Time DSS: disaster

Showing posts with label disaster. Show all posts

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,
swati
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
>
>
|||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[vbcol=seagreen]
> 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
>
|||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...
> create the database files...
> files from the CD, as it
> While
> can u
> user
>

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

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
> > >
> > >
> > >
> >
> >
>

Wednesday, March 21, 2012

Rebuild Master fails

Hi,
I am trying to test disaster recovery on a test server. I am trying to
create the master as though it has been corrupted. When I run the
Rebuildm.exe, it creates the master.mdf and mastlog.ldf files in the
C:\Program Files\MS SQL SERVER\DATA\MSSQL\Data directory from the
installation CD but it fails with an error -" Rebuild Master failed with
error -1:" and in the windows application event error log it says 17204
:FCB::Open failed: Could not open device C:\Program Files\Microsoft SQL
Server\DATA\MSSQL\data\master.mdf for virtual device number (VDN) 1.
I am not able to start the MSSQLSERVR service. I have tried three times
rebuilding the master but it has failed with the same error. Any help will be
greatly appreciated. Thanks.Hi,
I looked at the file attributes and unchecked the READ ONLY for the data and
log files for master, model and msdb databases. Now when I start the
MSSQLSERVR service it runs for just 1 - 2 seconds and then it stops. What
might be causing this? Thanks.
"sharman" wrote:
> Hi,
> I am trying to test disaster recovery on a test server. I am trying to
> create the master as though it has been corrupted. When I run the
> Rebuildm.exe, it creates the master.mdf and mastlog.ldf files in the
> C:\Program Files\MS SQL SERVER\DATA\MSSQL\Data directory from the
> installation CD but it fails with an error -" Rebuild Master failed with
> error -1:" and in the windows application event error log it says 17204
> :FCB::Open failed: Could not open device C:\Program Files\Microsoft SQL
> Server\DATA\MSSQL\data\master.mdf for virtual device number (VDN) 1.
> I am not able to start the MSSQLSERVR service. I have tried three times
> rebuilding the master but it has failed with the same error. Any help will be
> greatly appreciated. Thanks.|||> Now when I start the
> MSSQLSERVR service it runs for just 1 - 2 seconds and then it stops. What
> might be causing this?
Just about anything. Check the errorlog file for error messages.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:1F7F6AB4-A231-4AA3-B4B4-E4807F0E4B7F@.microsoft.com...
> Hi,
> I looked at the file attributes and unchecked the READ ONLY for the data and
> log files for master, model and msdb databases. Now when I start the
> MSSQLSERVR service it runs for just 1 - 2 seconds and then it stops. What
> might be causing this? Thanks.
> "sharman" wrote:
>> Hi,
>> I am trying to test disaster recovery on a test server. I am trying to
>> create the master as though it has been corrupted. When I run the
>> Rebuildm.exe, it creates the master.mdf and mastlog.ldf files in the
>> C:\Program Files\MS SQL SERVER\DATA\MSSQL\Data directory from the
>> installation CD but it fails with an error -" Rebuild Master failed with
>> error -1:" and in the windows application event error log it says 17204
>> :FCB::Open failed: Could not open device C:\Program Files\Microsoft SQL
>> Server\DATA\MSSQL\data\master.mdf for virtual device number (VDN) 1.
>> I am not able to start the MSSQLSERVR service. I have tried three times
>> rebuilding the master but it has failed with the same error. Any help will be
>> greatly appreciated. Thanks.|||Hi,
I was able to figure out the reason. The source file location for the mdf
and ldf files was on a CD with the Read Only attribute checked. I copied all
the files to a local disk, unchecked the Read Only attribute and rerun the
rebuildm.exe and it worked this time. This is in Microsoft KB 273572.
"Tibor Karaszi" wrote:
> > Now when I start the
> > MSSQLSERVR service it runs for just 1 - 2 seconds and then it stops. What
> > might be causing this?
> Just about anything. Check the errorlog file for error messages.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "sharman" <sharman@.discussions.microsoft.com> wrote in message
> news:1F7F6AB4-A231-4AA3-B4B4-E4807F0E4B7F@.microsoft.com...
> > Hi,
> >
> > I looked at the file attributes and unchecked the READ ONLY for the data and
> > log files for master, model and msdb databases. Now when I start the
> > MSSQLSERVR service it runs for just 1 - 2 seconds and then it stops. What
> > might be causing this? Thanks.
> >
> > "sharman" wrote:
> >
> >> Hi,
> >>
> >> I am trying to test disaster recovery on a test server. I am trying to
> >> create the master as though it has been corrupted. When I run the
> >> Rebuildm.exe, it creates the master.mdf and mastlog.ldf files in the
> >> C:\Program Files\MS SQL SERVER\DATA\MSSQL\Data directory from the
> >> installation CD but it fails with an error -" Rebuild Master failed with
> >> error -1:" and in the windows application event error log it says 17204
> >> :FCB::Open failed: Could not open device C:\Program Files\Microsoft SQL
> >> Server\DATA\MSSQL\data\master.mdf for virtual device number (VDN) 1.
> >>
> >> I am not able to start the MSSQLSERVR service. I have tried three times
> >> rebuilding the master but it has failed with the same error. Any help will be
> >> greatly appreciated. Thanks.
>

Monday, March 26, 2012

rebuilt option for master database

rebuilt option for master database

rebuilt option for master database

Wednesday, March 21, 2012

Rebuild Master fails

Rebuild Master fails

Rebuild Master fails

Real Time DSS

Blog Archive

About Me