Restoring security access using rsconfig?

Hi,
I have accidentally removed myself from the Home folder of my local
installation of reporting services. My security group was using an old
domain group and RS warned me that it was invalid. I deleted the entry
which was Content Manager, thinking that I was in the
BuiltIn/Administrators group and therefore would still have access to
localhost/reports. Unfortunately, I realised that I was not in the
administrators group on my PC (A company policy), so I lost all access
to my reports deployment. However, when I got added to the local
administrators group, I found that I still did not have access to the
Reports website.
My question is: Is there a way to manually add a user as a Content
Manager without using the http://localhost/Reports website? I seem to
recall a possible way using rsconfig, but have not been able to find a
relevant posting. I really do not want to uninstall and reinstall RS.
Thanks!To reply to myself in case other people ever have this problem:
I don't think you can do it with rsconfig.
In the end, I went into the ReportServer database and looked at the
users, roles and policies tables.
I found a user that was in the database as a Content Manager
(builtin/administrators is usually in there by default, but I had
another user there).
I then edited the PolicyUserRole table to change the user_id for a user
that had Content Manager access and a policy of "0" for my own user.
This let me back into the localhost/reports page where I then added my
domain name again. If you don't have a Content Manager already, take
the guid for that role and paste it into your role.
If I didn't have a user in there, I assume I could just add one, but I
am unsure about the generation of the guid.
I don't know what the official way to do this is, but as a hack, it
worked.
MDXQuery wrote:
> Hi,
> I have accidentally removed myself from the Home folder of my local
> installation of reporting services. My security group was using an old
> domain group and RS warned me that it was invalid. I deleted the entry
> which was Content Manager, thinking that I was in the
> BuiltIn/Administrators group and therefore would still have access to
> localhost/reports. Unfortunately, I realised that I was not in the
> administrators group on my PC (A company policy), so I lost all access
> to my reports deployment. However, when I got added to the local
> administrators group, I found that I still did not have access to the
> Reports website.
> My question is: Is there a way to manually add a user as a Content
> Manager without using the http://localhost/Reports website? I seem to
> recall a possible way using rsconfig, but have not been able to find a
> relevant posting. I really do not want to uninstall and reinstall RS.
> Thanks!|||If you can add yourself to the local admininstrator role of the server that
RS resides on, then you will automatically have all the rights you need with
RS.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"MDXQuery" <imgroup1@.hotmail.com> wrote in message
news:1125056826.979578.163790@.g43g2000cwa.googlegroups.com...
> To reply to myself in case other people ever have this problem:
> I don't think you can do it with rsconfig.
> In the end, I went into the ReportServer database and looked at the
> users, roles and policies tables.
> I found a user that was in the database as a Content Manager
> (builtin/administrators is usually in there by default, but I had
> another user there).
> I then edited the PolicyUserRole table to change the user_id for a user
> that had Content Manager access and a policy of "0" for my own user.
> This let me back into the localhost/reports page where I then added my
> domain name again. If you don't have a Content Manager already, take
> the guid for that role and paste it into your role.
> If I didn't have a user in there, I assume I could just add one, but I
> am unsure about the generation of the guid.
> I don't know what the official way to do this is, but as a hack, it
> worked.
>
>
> MDXQuery wrote:
>> Hi,
>> I have accidentally removed myself from the Home folder of my local
>> installation of reporting services. My security group was using an old
>> domain group and RS warned me that it was invalid. I deleted the entry
>> which was Content Manager, thinking that I was in the
>> BuiltIn/Administrators group and therefore would still have access to
>> localhost/reports. Unfortunately, I realised that I was not in the
>> administrators group on my PC (A company policy), so I lost all access
>> to my reports deployment. However, when I got added to the local
>> administrators group, I found that I still did not have access to the
>> Reports website.
>> My question is: Is there a way to manually add a user as a Content
>> Manager without using the http://localhost/Reports website? I seem to
>> recall a possible way using rsconfig, but have not been able to find a
>> relevant posting. I really do not want to uninstall and reinstall RS.
>> Thanks!
>

Restoring multiple transaction logs

Can anyone tell me if there is an easy way to restore
multiple transaction logs at the same time as a group from
within the Enterprise console? When I select multiple
(consecutive) transaction logs to restore I receive a
message about the transaction log not being part of "a
multifamily(RAID) media set". There has to be an easier
way.The error message say that you striped the backup, i.e., doesn't have anything to do with applying
multiple logs in sequence.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Jim" <brutjimmy@.yahoo.com> wrote in message news:041201c38391$a1798c60$a401280a@.phx.gbl...
> Can anyone tell me if there is an easy way to restore
> multiple transaction logs at the same time as a group from
> within the Enterprise console? When I select multiple
> (consecutive) transaction logs to restore I receive a
> message about the transaction log not being part of "a
> multifamily(RAID) media set". There has to be an easier
> way.|||It sounds like you are trying to restore multiple disk backup files together
as if it was a single "backup set".
In EM, under "Restore Database", you should be able to find a dialog that
lets you choose a "recovery plan" of multiple steps. There will be a "check
box" to click for each backup set to apply (starting with a full database
backup, etc).
"Jim" <brutjimmy@.yahoo.com> wrote in message
news:041201c38391$a1798c60$a401280a@.phx.gbl...
> Can anyone tell me if there is an easy way to restore
> multiple transaction logs at the same time as a group from
> within the Enterprise console? When I select multiple
> (consecutive) transaction logs to restore I receive a
> message about the transaction log not being part of "a
> multifamily(RAID) media set". There has to be an easier
> way.

restoring master database

Hi group!
I am trying to do the following for a recovery strategy: If server1 fails
all databases should be restored on server2. I did a restore of the master
database as described in some articles (starting in single user mode,
restoring...) after restoring my sql server does not start. An example error
message is:
FCB::Open failed: Could not open device d:\sql\MSSQL\data\pubs.mdf for
virtual device number (VDN) 1.
On server1 my data directory is d:\sql\mssql\data - on server2 my data
directory is d:\sql\mssql\mssql\data (configuration error during setup). He
wants to load all databases but of course does not have all the databases -
I have to recover them now - but how - I can't start the service..
Anyone an idea?
best regards
andyIf you are going to restore master from one server onto another, then you
need to have all DB's in the exact same location as they were on the
original server.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Andreas Wöckl" <woeckl@.esys.at> wrote in message
news:en%230WpR6FHA.1000@.tk2msftngp13.phx.gbl...
Hi group!
I am trying to do the following for a recovery strategy: If server1 fails
all databases should be restored on server2. I did a restore of the master
database as described in some articles (starting in single user mode,
restoring...) after restoring my sql server does not start. An example error
message is:
FCB::Open failed: Could not open device d:\sql\MSSQL\data\pubs.mdf for
virtual device number (VDN) 1.
On server1 my data directory is d:\sql\mssql\data - on server2 my data
directory is d:\sql\mssql\mssql\data (configuration error during setup). He
wants to load all databases but of course does not have all the databases -
I have to recover them now - but how - I can't start the service..
Anyone an idea?
best regards
andy|||hi tom!
hmm - but what are the steps that I have to take - Am I right that I first
have to restore all the databases and the last step is to restore the master
database?
best regards
andy
"Tom Moreau" <tom@.dont.spam.me.cips.ca> schrieb im Newsbeitrag
news:%23jM$tsR6FHA.4076@.tk2msftngp13.phx.gbl...
> If you are going to restore master from one server onto another, then you
> need to have all DB's in the exact same location as they were on the
> original server.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "Andreas Wöckl" <woeckl@.esys.at> wrote in message
> news:en%230WpR6FHA.1000@.tk2msftngp13.phx.gbl...
> Hi group!
> I am trying to do the following for a recovery strategy: If server1 fails
> all databases should be restored on server2. I did a restore of the master
> database as described in some articles (starting in single user mode,
> restoring...) after restoring my sql server does not start. An example
> error
> message is:
> FCB::Open failed: Could not open device d:\sql\MSSQL\data\pubs.mdf for
> virtual device number (VDN) 1.
> On server1 my data directory is d:\sql\mssql\data - on server2 my data
> directory is d:\sql\mssql\mssql\data (configuration error during setup).
> He
> wants to load all databases but of course does not have all the
> databases -
> I have to recover them now - but how - I can't start the service..
> Anyone an idea?
> best regards
> andy
>|||A technique we have used successfully in tests is:
1- Install SQL Server on new server
2- Restore individual databases to new server using one of three techniques:
a- Restore with third party software with new location
b- restore with manual restore command with move option
c- re-attach copies of detached databases
3- Get a list of the users from each application database
4- Either run sp_helplogins (and related scripts/procedures) or use the list
from 3 to rebuild access.
--
Joseph R.P. Maloney, CSP,CCP,CDP
"Andreas Wöckl" wrote:
> hi tom!
> hmm - but what are the steps that I have to take - Am I right that I first
> have to restore all the databases and the last step is to restore the master
> database?
> best regards
> andy
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> schrieb im Newsbeitrag
> news:%23jM$tsR6FHA.4076@.tk2msftngp13.phx.gbl...
> > If you are going to restore master from one server onto another, then you
> > need to have all DB's in the exact same location as they were on the
> > original server.
> >
> > --
> > Tom
> >
> > ----
> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> > SQL Server MVP
> > Columnist, SQL Server Professional
> > Toronto, ON Canada
> > www.pinpub.com
> > .
> > "Andreas Wöckl" <woeckl@.esys.at> wrote in message
> > news:en%230WpR6FHA.1000@.tk2msftngp13.phx.gbl...
> > Hi group!
> >
> > I am trying to do the following for a recovery strategy: If server1 fails
> > all databases should be restored on server2. I did a restore of the master
> > database as described in some articles (starting in single user mode,
> > restoring...) after restoring my sql server does not start. An example
> > error
> > message is:
> >
> > FCB::Open failed: Could not open device d:\sql\MSSQL\data\pubs.mdf for
> > virtual device number (VDN) 1.
> >
> > On server1 my data directory is d:\sql\mssql\data - on server2 my data
> > directory is d:\sql\mssql\mssql\data (configuration error during setup).
> > He
> > wants to load all databases but of course does not have all the
> > databases -
> > I have to recover them now - but how - I can't start the service..
> >
> > Anyone an idea?
> >
> > best regards
> >
> > andy
> >
> >
>
>|||What I do is restore the app DB's, then msdb then master. As I said
before - make sure they are in the exact same folders with the exact same
filenames as on your source server.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
"Andreas Wöckl" <woeckl@.esys.at> wrote in message
news:OglOL2R6FHA.3048@.TK2MSFTNGP10.phx.gbl...
> hi tom!
> hmm - but what are the steps that I have to take - Am I right that I first
> have to restore all the databases and the last step is to restore the
> master database?
> best regards
> andy
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> schrieb im Newsbeitrag
> news:%23jM$tsR6FHA.4076@.tk2msftngp13.phx.gbl...
>> If you are going to restore master from one server onto another, then you
>> need to have all DB's in the exact same location as they were on the
>> original server.
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON Canada
>> www.pinpub.com
>> .
>> "Andreas Wöckl" <woeckl@.esys.at> wrote in message
>> news:en%230WpR6FHA.1000@.tk2msftngp13.phx.gbl...
>> Hi group!
>> I am trying to do the following for a recovery strategy: If server1 fails
>> all databases should be restored on server2. I did a restore of the
>> master
>> database as described in some articles (starting in single user mode,
>> restoring...) after restoring my sql server does not start. An example
>> error
>> message is:
>> FCB::Open failed: Could not open device d:\sql\MSSQL\data\pubs.mdf for
>> virtual device number (VDN) 1.
>> On server1 my data directory is d:\sql\mssql\data - on server2 my data
>> directory is d:\sql\mssql\mssql\data (configuration error during setup).
>> He
>> wants to load all databases but of course does not have all the
>> databases -
>> I have to recover them now - but how - I can't start the service..
>> Anyone an idea?
>> best regards
>> andy
>>
>|||We restore the Master, MSDB before rebooting, and then the individual
databases.
"Tom Moreau" wrote:
> What I do is restore the app DB's, then msdb then master. As I said
> before - make sure they are in the exact same folders with the exact same
> filenames as on your source server.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> "Andreas Wöckl" <woeckl@.esys.at> wrote in message
> news:OglOL2R6FHA.3048@.TK2MSFTNGP10.phx.gbl...
> > hi tom!
> >
> > hmm - but what are the steps that I have to take - Am I right that I first
> > have to restore all the databases and the last step is to restore the
> > master database?
> >
> > best regards
> >
> > andy
> >
> >
> > "Tom Moreau" <tom@.dont.spam.me.cips.ca> schrieb im Newsbeitrag
> > news:%23jM$tsR6FHA.4076@.tk2msftngp13.phx.gbl...
> >> If you are going to restore master from one server onto another, then you
> >> need to have all DB's in the exact same location as they were on the
> >> original server.
> >>
> >> --
> >> Tom
> >>
> >> ----
> >> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> >> SQL Server MVP
> >> Columnist, SQL Server Professional
> >> Toronto, ON Canada
> >> www.pinpub.com
> >> .
> >> "Andreas Wöckl" <woeckl@.esys.at> wrote in message
> >> news:en%230WpR6FHA.1000@.tk2msftngp13.phx.gbl...
> >> Hi group!
> >>
> >> I am trying to do the following for a recovery strategy: If server1 fails
> >> all databases should be restored on server2. I did a restore of the
> >> master
> >> database as described in some articles (starting in single user mode,
> >> restoring...) after restoring my sql server does not start. An example
> >> error
> >> message is:
> >>
> >> FCB::Open failed: Could not open device d:\sql\MSSQL\data\pubs.mdf for
> >> virtual device number (VDN) 1.
> >>
> >> On server1 my data directory is d:\sql\mssql\data - on server2 my data
> >> directory is d:\sql\mssql\mssql\data (configuration error during setup).
> >> He
> >> wants to load all databases but of course does not have all the
> >> databases -
> >> I have to recover them now - but how - I can't start the service..
> >>
> >> Anyone an idea?
> >>
> >> best regards
> >>
> >> andy
> >>
> >>
> >
> >
>
>|||Here's the info I mentioned from BOL:
To recover from a disaster, perform the following steps after acquiring
suitable replacement hardware:
Install Windows NT 4.0 or Windows 2000, and apply the appropriate service
pack. Verify that appropriate domain functionality exists.
Install SQL Server, and apply the appropriate service pack. Restore the
master and msdb database backups. Restart the server after restoring the
master database.
Reconfigure the server for the appropriate network libraries and security
mode.
Confirm that SQL Server is running properly by checking SQL Server Service
Manager and the Windows application log. If the Windows NT 4.0 or Windows
2000 name was changed, use sp_dropserver and sp_addserver to match it with
the SQL Server computer name.
Restore and recover each database according to its recovery plan.
Verify the availability of the system. Run a base functionality script to
ensure correct operation.
Allow users to resume normal usage.
"Tom Moreau" wrote:
> What I do is restore the app DB's, then msdb then master. As I said
> before - make sure they are in the exact same folders with the exact same
> filenames as on your source server.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> "Andreas Wöckl" <woeckl@.esys.at> wrote in message
> news:OglOL2R6FHA.3048@.TK2MSFTNGP10.phx.gbl...
> > hi tom!
> >
> > hmm - but what are the steps that I have to take - Am I right that I first
> > have to restore all the databases and the last step is to restore the
> > master database?
> >
> > best regards
> >
> > andy
> >
> >
> > "Tom Moreau" <tom@.dont.spam.me.cips.ca> schrieb im Newsbeitrag
> > news:%23jM$tsR6FHA.4076@.tk2msftngp13.phx.gbl...
> >> If you are going to restore master from one server onto another, then you
> >> need to have all DB's in the exact same location as they were on the
> >> original server.
> >>
> >> --
> >> Tom
> >>
> >> ----
> >> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> >> SQL Server MVP
> >> Columnist, SQL Server Professional
> >> Toronto, ON Canada
> >> www.pinpub.com
> >> .
> >> "Andreas Wöckl" <woeckl@.esys.at> wrote in message
> >> news:en%230WpR6FHA.1000@.tk2msftngp13.phx.gbl...
> >> Hi group!
> >>
> >> I am trying to do the following for a recovery strategy: If server1 fails
> >> all databases should be restored on server2. I did a restore of the
> >> master
> >> database as described in some articles (starting in single user mode,
> >> restoring...) after restoring my sql server does not start. An example
> >> error
> >> message is:
> >>
> >> FCB::Open failed: Could not open device d:\sql\MSSQL\data\pubs.mdf for
> >> virtual device number (VDN) 1.
> >>
> >> On server1 my data directory is d:\sql\mssql\data - on server2 my data
> >> directory is d:\sql\mssql\mssql\data (configuration error during setup).
> >> He
> >> wants to load all databases but of course does not have all the
> >> databases -
> >> I have to recover them now - but how - I can't start the service..
> >>
> >> Anyone an idea?
> >>
> >> best regards
> >>
> >> andy
> >>
> >>
> >
> >
>
>|||The problem with that is that you get error messages, since the app DB's
don't (yet) exist.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
"burt_king" <burt_king@.yahoo.com> wrote in message
news:1101C4D3-115D-43C8-A7FF-01DC1D728098@.microsoft.com...
> We restore the Master, MSDB before rebooting, and then the individual
> databases.
> "Tom Moreau" wrote:
>> What I do is restore the app DB's, then msdb then master. As I said
>> before - make sure they are in the exact same folders with the exact same
>> filenames as on your source server.
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON Canada
>> www.pinpub.com
>> "Andreas Wöckl" <woeckl@.esys.at> wrote in message
>> news:OglOL2R6FHA.3048@.TK2MSFTNGP10.phx.gbl...
>> > hi tom!
>> >
>> > hmm - but what are the steps that I have to take - Am I right that I
>> > first
>> > have to restore all the databases and the last step is to restore the
>> > master database?
>> >
>> > best regards
>> >
>> > andy
>> >
>> >
>> > "Tom Moreau" <tom@.dont.spam.me.cips.ca> schrieb im Newsbeitrag
>> > news:%23jM$tsR6FHA.4076@.tk2msftngp13.phx.gbl...
>> >> If you are going to restore master from one server onto another, then
>> >> you
>> >> need to have all DB's in the exact same location as they were on the
>> >> original server.
>> >>
>> >> --
>> >> Tom
>> >>
>> >> ----
>> >> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> >> SQL Server MVP
>> >> Columnist, SQL Server Professional
>> >> Toronto, ON Canada
>> >> www.pinpub.com
>> >> .
>> >> "Andreas Wöckl" <woeckl@.esys.at> wrote in message
>> >> news:en%230WpR6FHA.1000@.tk2msftngp13.phx.gbl...
>> >> Hi group!
>> >>
>> >> I am trying to do the following for a recovery strategy: If server1
>> >> fails
>> >> all databases should be restored on server2. I did a restore of the
>> >> master
>> >> database as described in some articles (starting in single user mode,
>> >> restoring...) after restoring my sql server does not start. An example
>> >> error
>> >> message is:
>> >>
>> >> FCB::Open failed: Could not open device d:\sql\MSSQL\data\pubs.mdf for
>> >> virtual device number (VDN) 1.
>> >>
>> >> On server1 my data directory is d:\sql\mssql\data - on server2 my data
>> >> directory is d:\sql\mssql\mssql\data (configuration error during
>> >> setup).
>> >> He
>> >> wants to load all databases but of course does not have all the
>> >> databases -
>> >> I have to recover them now - but how - I can't start the service..
>> >>
>> >> Anyone an idea?
>> >>
>> >> best regards
>> >>
>> >> andy
>> >>
>> >>
>> >
>> >
>>|||hi tom!
thanks for your help - the recovery with the same paths was o.k - I restored
the user databases and then the master database. I still have some troubles
with the msdb because sql server prompts that the msdb has been created with
a different version - both sql servers have service pack 4..?
best regards
andy
"Tom Moreau" <tom@.dont.spam.me.cips.ca> schrieb im Newsbeitrag
news:%2345V%232T6FHA.2896@.TK2MSFTNGP10.phx.gbl...
> What I do is restore the app DB's, then msdb then master. As I said
> before - make sure they are in the exact same folders with the exact same
> filenames as on your source server.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> "Andreas Wöckl" <woeckl@.esys.at> wrote in message
> news:OglOL2R6FHA.3048@.TK2MSFTNGP10.phx.gbl...
>> hi tom!
>> hmm - but what are the steps that I have to take - Am I right that I
>> first have to restore all the databases and the last step is to restore
>> the master database?
>> best regards
>> andy
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> schrieb im Newsbeitrag
>> news:%23jM$tsR6FHA.4076@.tk2msftngp13.phx.gbl...
>> If you are going to restore master from one server onto another, then
>> you
>> need to have all DB's in the exact same location as they were on the
>> original server.
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON Canada
>> www.pinpub.com
>> .
>> "Andreas Wöckl" <woeckl@.esys.at> wrote in message
>> news:en%230WpR6FHA.1000@.tk2msftngp13.phx.gbl...
>> Hi group!
>> I am trying to do the following for a recovery strategy: If server1
>> fails
>> all databases should be restored on server2. I did a restore of the
>> master
>> database as described in some articles (starting in single user mode,
>> restoring...) after restoring my sql server does not start. An example
>> error
>> message is:
>> FCB::Open failed: Could not open device d:\sql\MSSQL\data\pubs.mdf for
>> virtual device number (VDN) 1.
>> On server1 my data directory is d:\sql\mssql\data - on server2 my data
>> directory is d:\sql\mssql\mssql\data (configuration error during setup).
>> He
>> wants to load all databases but of course does not have all the
>> databases -
>> I have to recover them now - but how - I can't start the service..
>> Anyone an idea?
>> best regards
>> andy
>>
>>
>|||Hmm. Do both have the same hotfixes?
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
"Andreas Wöckl" <woeckl@.esys.at> wrote in message
news:eZ9onDb6FHA.2608@.tk2msftngp13.phx.gbl...
> hi tom!
> thanks for your help - the recovery with the same paths was o.k - I
> restored the user databases and then the master database. I still have
> some troubles with the msdb because sql server prompts that the msdb has
> been created with a different version - both sql servers have service pack
> 4..?
> best regards
> andy
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> schrieb im Newsbeitrag
> news:%2345V%232T6FHA.2896@.TK2MSFTNGP10.phx.gbl...
>> What I do is restore the app DB's, then msdb then master. As I said
>> before - make sure they are in the exact same folders with the exact same
>> filenames as on your source server.
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON Canada
>> www.pinpub.com
>> "Andreas Wöckl" <woeckl@.esys.at> wrote in message
>> news:OglOL2R6FHA.3048@.TK2MSFTNGP10.phx.gbl...
>> hi tom!
>> hmm - but what are the steps that I have to take - Am I right that I
>> first have to restore all the databases and the last step is to restore
>> the master database?
>> best regards
>> andy
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> schrieb im Newsbeitrag
>> news:%23jM$tsR6FHA.4076@.tk2msftngp13.phx.gbl...
>> If you are going to restore master from one server onto another, then
>> you
>> need to have all DB's in the exact same location as they were on the
>> original server.
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON Canada
>> www.pinpub.com
>> .
>> "Andreas Wöckl" <woeckl@.esys.at> wrote in message
>> news:en%230WpR6FHA.1000@.tk2msftngp13.phx.gbl...
>> Hi group!
>> I am trying to do the following for a recovery strategy: If server1
>> fails
>> all databases should be restored on server2. I did a restore of the
>> master
>> database as described in some articles (starting in single user mode,
>> restoring...) after restoring my sql server does not start. An example
>> error
>> message is:
>> FCB::Open failed: Could not open device d:\sql\MSSQL\data\pubs.mdf for
>> virtual device number (VDN) 1.
>> On server1 my data directory is d:\sql\mssql\data - on server2 my data
>> directory is d:\sql\mssql\mssql\data (configuration error during
>> setup). He
>> wants to load all databases but of course does not have all the
>> databases -
>> I have to recover them now - but how - I can't start the service..
>> Anyone an idea?
>> best regards
>> andy
>>
>>
>>
>

restoring from file group

Hello,
I would like to do a restore from file group for one of my databases. I was able to do a restore when I had the database under FULL recovery model. Is there a way to restore from file groups under the "SIMPLE " recovery model ie without performing a transaction log.
ThanksWhat was the statement used to restore?
I think there shouldn't be any issue pertaining to recovery model set on the database.|||there is a problem with tlog backups. i know that you cannot backup the tlog while the db is in simple mode.

i'm not sure however that there are any issues with recovery. i have recovered northwind many times and it is in simple mode.