Showing posts with label installation. Show all posts
Showing posts with label installation. Show all posts

Friday, March 23, 2012

Restoring SQL Server Database in to new installation

Hi all,

just now I joined in this forum.its nice to see this.

I have a problem here with SQL Server in the restore process.

my database got crashed here.i installed a new copy of the SQL Server.

i wnt to restore the backup of the database in this new installation.

can u please help me how to do it.

Thanks in advance.

Rajendar Reddy.AThis page might help, it also has some links within in to help you.

http://support.microsoft.com/default.aspx?kbid=314546#9

HTH

Wednesday, March 21, 2012

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

Monday, March 12, 2012

Restoring Master Database

Hi !
I'm about to move a SQL Server installation to a new server. Is using
backup/restore to move all databases. Both servers is SQL Server 2000 with
SP4.
I have read all books online topics about this (and I have done this kind of
operation before) but somehow I'm missing out on something, hope you can see
what I'm missing =)
This will descibe the actions I have taken
1. Full backup of all databases on server1.
2. Copy all backupfiles to server2.
3. Starting SQL Server with the -c -m switch for Single mode on server2
4. Restoring master database on server2 with the following syntax
RESTORE DATABASE master FROM disk='E:\MSSQL\backup\master.bak'
WITH MOVE 'master' to 'E:\mssql\data\master.mdf',
MOVE 'mastlog' to 'E:\mssql\data\mastlog.ldf',
REPLACE
go
5. Message from QU says that restore worked fine and that SQL Server will be
shut down.
Then the problem starts! I can't get SQL Server to start again... The
service goes to "starting" mode and the directly to "stopping". Of cource
there are several messages in logs saying that the "user" databases can't be
recovered. But that's "normal" right? Since the Master database is pointing
out database that I havn't restored yet.
But what do I need to do more to be able to restore user databases and get
server up and running'
Regards FredrikThe problem is probably that you also have file references for model and tempdb in the restored
master database. I think you have some good info about thin is KB 224071.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Fredrik" <Fredrik@.discussions.microsoft.com> wrote in message
news:D484D6E7-6627-47E2-A070-95E969267BC1@.microsoft.com...
> Hi !
> I'm about to move a SQL Server installation to a new server. Is using
> backup/restore to move all databases. Both servers is SQL Server 2000 with
> SP4.
> I have read all books online topics about this (and I have done this kind of
> operation before) but somehow I'm missing out on something, hope you can see
> what I'm missing =)
> This will descibe the actions I have taken
> 1. Full backup of all databases on server1.
> 2. Copy all backupfiles to server2.
> 3. Starting SQL Server with the -c -m switch for Single mode on server2
> 4. Restoring master database on server2 with the following syntax
> RESTORE DATABASE master FROM disk='E:\MSSQL\backup\master.bak'
> WITH MOVE 'master' to 'E:\mssql\data\master.mdf',
> MOVE 'mastlog' to 'E:\mssql\data\mastlog.ldf',
> REPLACE
> go
> 5. Message from QU says that restore worked fine and that SQL Server will be
> shut down.
> Then the problem starts! I can't get SQL Server to start again... The
> service goes to "starting" mode and the directly to "stopping". Of cource
> there are several messages in logs saying that the "user" databases can't be
> recovered. But that's "normal" right? Since the Master database is pointing
> out database that I havn't restored yet.
> But what do I need to do more to be able to restore user databases and get
> server up and running'
> Regards Fredrik
>
>|||Thanx Tibor. That really pointed me in the right direction and saved me a lot
of time!
Thanks again!
/Fredrik
"Tibor Karaszi" wrote:
> The problem is probably that you also have file references for model and tempdb in the restored
> master database. I think you have some good info about thin is KB 224071.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Fredrik" <Fredrik@.discussions.microsoft.com> wrote in message
> news:D484D6E7-6627-47E2-A070-95E969267BC1@.microsoft.com...
> > Hi !
> >
> > I'm about to move a SQL Server installation to a new server. Is using
> > backup/restore to move all databases. Both servers is SQL Server 2000 with
> > SP4.
> >
> > I have read all books online topics about this (and I have done this kind of
> > operation before) but somehow I'm missing out on something, hope you can see
> > what I'm missing =)
> >
> > This will descibe the actions I have taken
> >
> > 1. Full backup of all databases on server1.
> > 2. Copy all backupfiles to server2.
> > 3. Starting SQL Server with the -c -m switch for Single mode on server2
> > 4. Restoring master database on server2 with the following syntax
> > RESTORE DATABASE master FROM disk='E:\MSSQL\backup\master.bak'
> > WITH MOVE 'master' to 'E:\mssql\data\master.mdf',
> > MOVE 'mastlog' to 'E:\mssql\data\mastlog.ldf',
> > REPLACE
> > go
> > 5. Message from QU says that restore worked fine and that SQL Server will be
> > shut down.
> >
> > Then the problem starts! I can't get SQL Server to start again... The
> > service goes to "starting" mode and the directly to "stopping". Of cource
> > there are several messages in logs saying that the "user" databases can't be
> > recovered. But that's "normal" right? Since the Master database is pointing
> > out database that I havn't restored yet.
> >
> > But what do I need to do more to be able to restore user databases and get
> > server up and running'
> >
> > Regards Fredrik
> >
> >
> >
>
>

Restoring Master Database

Hi !
I'm about to move a SQL Server installation to a new server. Is using
backup/restore to move all databases. Both servers is SQL Server 2000 with
SP4.
I have read all books online topics about this (and I have done this kind of
operation before) but somehow I'm missing out on something, hope you can see
what I'm missing =)
This will descibe the actions I have taken
1. Full backup of all databases on server1.
2. Copy all backupfiles to server2.
3. Starting SQL Server with the -c -m switch for Single mode on server2
4. Restoring master database on server2 with the following syntax
RESTORE DATABASE master FROM disk='E:\MSSQL\backup\master.bak'
WITH MOVE 'master' to 'E:\mssql\data\master.mdf',
MOVE 'mastlog' to 'E:\mssql\data\mastlog.ldf',
REPLACE
go
5. Message from QU says that restore worked fine and that SQL Server will be
shut down.
Then the problem starts! I can't get SQL Server to start again... The
service goes to "starting" mode and the directly to "stopping". Of cource
there are several messages in logs saying that the "user" databases can't be
recovered. But that's "normal" right? Since the Master database is pointing
out database that I havn't restored yet.
But what do I need to do more to be able to restore user databases and get
server up and running'
Regards FredrikThe problem is probably that you also have file references for model and tem
pdb in the restored
master database. I think you have some good info about thin is KB 224071.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Fredrik" <Fredrik@.discussions.microsoft.com> wrote in message
news:D484D6E7-6627-47E2-A070-95E969267BC1@.microsoft.com...
> Hi !
> I'm about to move a SQL Server installation to a new server. Is using
> backup/restore to move all databases. Both servers is SQL Server 2000 with
> SP4.
> I have read all books online topics about this (and I have done this kind
of
> operation before) but somehow I'm missing out on something, hope you can s
ee
> what I'm missing =)
> This will descibe the actions I have taken
> 1. Full backup of all databases on server1.
> 2. Copy all backupfiles to server2.
> 3. Starting SQL Server with the -c -m switch for Single mode on server2
> 4. Restoring master database on server2 with the following syntax
> RESTORE DATABASE master FROM disk='E:\MSSQL\backup\master.bak'
> WITH MOVE 'master' to 'E:\mssql\data\master.mdf',
> MOVE 'mastlog' to 'E:\mssql\data\mastlog.ldf',
> REPLACE
> go
> 5. Message from QU says that restore worked fine and that SQL Server will
be
> shut down.
> Then the problem starts! I can't get SQL Server to start again... The
> service goes to "starting" mode and the directly to "stopping". Of cource
> there are several messages in logs saying that the "user" databases can't
be
> recovered. But that's "normal" right? Since the Master database is pointin
g
> out database that I havn't restored yet.
> But what do I need to do more to be able to restore user databases and get
> server up and running'
> Regards Fredrik
>
>|||Thanx Tibor. That really pointed me in the right direction and saved me a lo
t
of time!
Thanks again!
/Fredrik
"Tibor Karaszi" wrote:

> The problem is probably that you also have file references for model and t
empdb in the restored
> master database. I think you have some good info about thin is KB 224071.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Fredrik" <Fredrik@.discussions.microsoft.com> wrote in message
> news:D484D6E7-6627-47E2-A070-95E969267BC1@.microsoft.com...
>
>