I try sql setup newsgroup but nobody answer.
Hi,
I have a SQL server dev edition in windows XP pro, I wan to install
Reporting Services but I have an error at the end "error code 25619".
It creates two databases--> ReportServer and ReportServerTempDB.
How can I pass this error? Any ideas?
Tks in advance
JohnnyEnable IWAM_ComputerName account if it is disabled. Also, if Distributed
Transaction Coordinator service is not running, start it. Then rerun Setup.
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"JFB" <jfb@.newSQL.com> wrote in message
news:%23IYqsSHWEHA.4024@.TK2MSFTNGP09.phx.gbl...
> I try sql setup newsgroup but nobody answer.
> Hi,
> I have a SQL server dev edition in windows XP pro, I wan to install
> Reporting Services but I have an error at the end "error code 25619".
> It creates two databases--> ReportServer and ReportServerTempDB.
> How can I pass this error? Any ideas?
> Tks in advance
> Johnny
>|||Tks for reply Ravi... I got it, the DTC was off.
Johnny
"Ravi Mumulla (Microsoft)" <ravimu@.microsoft.com> wrote in message
news:%231aZ6NJWEHA.4064@.TK2MSFTNGP11.phx.gbl...
> Enable IWAM_ComputerName account if it is disabled. Also, if Distributed
> Transaction Coordinator service is not running, start it. Then rerun
Setup.
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "JFB" <jfb@.newSQL.com> wrote in message
> news:%23IYqsSHWEHA.4024@.TK2MSFTNGP09.phx.gbl...
> > I try sql setup newsgroup but nobody answer.
> >
> > Hi,
> > I have a SQL server dev edition in windows XP pro, I wan to install
> > Reporting Services but I have an error at the end "error code 25619".
> > It creates two databases--> ReportServer and ReportServerTempDB.
> > How can I pass this error? Any ideas?
> > Tks in advance
> > Johnny
> >
> >
>
Showing posts with label newsgroup. Show all posts
Showing posts with label newsgroup. Show all posts
Monday, March 26, 2012
Monday, March 19, 2012
Error in restore
Dear Newsgroup,
I am using sql server 2000 over win 2000 server with service pack 4.
I have been given a back up of a database (I have tried both from T-SQL and
Enterprise Manager)
T-SQL
RESTORE FILELISTONLY
FROM DISK = 'c:\A.bck'
RESTORE DATABASE B
FROM DISK = 'c:\A.bck'
WITH MOVE 'A_Data' TO 'c:\test\B.mdf',
MOVE 'A_Log' TO 'c:\test\B.ldf'
and as I try to restore I get the following error :
Server: Msg 3154, Level 16, State 2, Line 1
The backup set holds a backup of a database other than the existing 'B'
database.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Would you kindly help me ''?
Thank you in advance,
YassYou need to specify the REPLACE option. This is needed when the target
database exists and the backup was created from a database with a different
name.
RESTORE DATABASE B
FROM DISK = 'c:\A.bck'
WITH MOVE 'A_Data' TO 'c:\test\B.mdf',
MOVE 'A_Log' TO 'c:\test\B.ldf',
REPLACE
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Yass" <gol_e_yass@.yahoo.com> wrote in message
news:bv0tq4$1r58@.news.emirates.net.ae...
> Dear Newsgroup,
>
> I am using sql server 2000 over win 2000 server with service pack 4.
> I have been given a back up of a database (I have tried both from T-SQL
and
> Enterprise Manager)
> T-SQL
> RESTORE FILELISTONLY
> FROM DISK = 'c:\A.bck'
> RESTORE DATABASE B
> FROM DISK = 'c:\A.bck'
> WITH MOVE 'A_Data' TO 'c:\test\B.mdf',
> MOVE 'A_Log' TO 'c:\test\B.ldf'
> and as I try to restore I get the following error :
> Server: Msg 3154, Level 16, State 2, Line 1
> The backup set holds a backup of a database other than the existing 'B'
> database.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> Would you kindly help me ''?
> Thank you in advance,
> Yass
>
>
>
I am using sql server 2000 over win 2000 server with service pack 4.
I have been given a back up of a database (I have tried both from T-SQL and
Enterprise Manager)
T-SQL
RESTORE FILELISTONLY
FROM DISK = 'c:\A.bck'
RESTORE DATABASE B
FROM DISK = 'c:\A.bck'
WITH MOVE 'A_Data' TO 'c:\test\B.mdf',
MOVE 'A_Log' TO 'c:\test\B.ldf'
and as I try to restore I get the following error :
Server: Msg 3154, Level 16, State 2, Line 1
The backup set holds a backup of a database other than the existing 'B'
database.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Would you kindly help me ''?
Thank you in advance,
YassYou need to specify the REPLACE option. This is needed when the target
database exists and the backup was created from a database with a different
name.
RESTORE DATABASE B
FROM DISK = 'c:\A.bck'
WITH MOVE 'A_Data' TO 'c:\test\B.mdf',
MOVE 'A_Log' TO 'c:\test\B.ldf',
REPLACE
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Yass" <gol_e_yass@.yahoo.com> wrote in message
news:bv0tq4$1r58@.news.emirates.net.ae...
> Dear Newsgroup,
>
> I am using sql server 2000 over win 2000 server with service pack 4.
> I have been given a back up of a database (I have tried both from T-SQL
and
> Enterprise Manager)
> T-SQL
> RESTORE FILELISTONLY
> FROM DISK = 'c:\A.bck'
> RESTORE DATABASE B
> FROM DISK = 'c:\A.bck'
> WITH MOVE 'A_Data' TO 'c:\test\B.mdf',
> MOVE 'A_Log' TO 'c:\test\B.ldf'
> and as I try to restore I get the following error :
> Server: Msg 3154, Level 16, State 2, Line 1
> The backup set holds a backup of a database other than the existing 'B'
> database.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> Would you kindly help me ''?
> Thank you in advance,
> Yass
>
>
>
Error in restore
Dear Newsgroup,
I am using sql server 2000 over win 2000 server with service pack 4.
I have been given a back up of a database (I have tried both from T-SQL and
Enterprise Manager)
T-SQL
RESTORE FILELISTONLY
FROM DISK = 'c:\A.bck'
RESTORE DATABASE B
FROM DISK = 'c:\A.bck'
WITH MOVE 'A_Data' TO 'c:\test\B.mdf',
MOVE 'A_Log' TO 'c:\test\B.ldf'
and as I try to restore I get the following error :
Server: Msg 3154, Level 16, State 2, Line 1
The backup set holds a backup of a database other than the existing 'B'
database.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Would you kindly help me ''?
Thank you in advance,
YassYou need to specify the REPLACE option. This is needed when the target
database exists and the backup was created from a database with a different
name.
RESTORE DATABASE B
FROM DISK = 'c:\A.bck'
WITH MOVE 'A_Data' TO 'c:\test\B.mdf',
MOVE 'A_Log' TO 'c:\test\B.ldf',
REPLACE
Hope this helps.
Dan Guzman
SQL Server MVP
"Yass" <gol_e_yass@.yahoo.com> wrote in message
news:bv0tq4$1r58@.news.emirates.net.ae...
and
I am using sql server 2000 over win 2000 server with service pack 4.
I have been given a back up of a database (I have tried both from T-SQL and
Enterprise Manager)
T-SQL
RESTORE FILELISTONLY
FROM DISK = 'c:\A.bck'
RESTORE DATABASE B
FROM DISK = 'c:\A.bck'
WITH MOVE 'A_Data' TO 'c:\test\B.mdf',
MOVE 'A_Log' TO 'c:\test\B.ldf'
and as I try to restore I get the following error :
Server: Msg 3154, Level 16, State 2, Line 1
The backup set holds a backup of a database other than the existing 'B'
database.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Would you kindly help me ''?
Thank you in advance,
YassYou need to specify the REPLACE option. This is needed when the target
database exists and the backup was created from a database with a different
name.
RESTORE DATABASE B
FROM DISK = 'c:\A.bck'
WITH MOVE 'A_Data' TO 'c:\test\B.mdf',
MOVE 'A_Log' TO 'c:\test\B.ldf',
REPLACE
Hope this helps.
Dan Guzman
SQL Server MVP
"Yass" <gol_e_yass@.yahoo.com> wrote in message
news:bv0tq4$1r58@.news.emirates.net.ae...
quote:
> Dear Newsgroup,
>
> I am using sql server 2000 over win 2000 server with service pack 4.
> I have been given a back up of a database (I have tried both from T-SQL
and
quote:
> Enterprise Manager)
> T-SQL
> RESTORE FILELISTONLY
> FROM DISK = 'c:\A.bck'
> RESTORE DATABASE B
> FROM DISK = 'c:\A.bck'
> WITH MOVE 'A_Data' TO 'c:\test\B.mdf',
> MOVE 'A_Log' TO 'c:\test\B.ldf'
> and as I try to restore I get the following error :
> Server: Msg 3154, Level 16, State 2, Line 1
> The backup set holds a backup of a database other than the existing 'B'
> database.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> Would you kindly help me ''?
> Thank you in advance,
> Yass
>
>
>
Subscribe to:
Posts (Atom)