Mirror database is not accessible when Mirroring is stopped.

Hi,

I've a very basic doubt about database mirroring. I did setup a database mirroring session with the help of SQL Server Management Studio between the server A (db1) and B(db1). When is stop database mirroring by using the command button "Stop Mirroring" available in the mirroring page of SQL Server Management Studio , the mirror database{ B(db1) } goes to state "Restoring...". After stopping the mirroring i'm not able to access the mirror database.

Can you please tell me how to bring mirror database B(db1) to operation mode so that we can start working with that database?

Regards,

Gopi

Hi Gopi. Hitting the 'Stop Mirroring' Button will in effect remove the database mirroring session for that particular database, not cause a failover...not sure if that's what you are trying to do, or if you really do mean to stop mirroring alltogether.

To simply bring the mirror copy into an operational state at the point you are at now, simply run something like the following on the mirror instance:

restore database <mirror database name> with recovery

This is very similar to as if you were restoring t-log backups to a particular database and wanted to recover it after applying the last one.

However, bear in mind that following the procedure you followed above is not what you'd want to do if you are in fact trying to 'failover' to the mirror copy of the database. For information on what you'd want to do there, click the 'Help' button from the mirroring dialog you were on above and see the topic titled 'Failover'.

HTH,

Minimum version of Visual Studio.NET

What is the minimum requirement or version of Visual Studio.NET
necessary for editing reports when running Reporting Services. I am
running on a SQL 2000 sp3 and Windows 2003 server.Anything that comes with VS.2003 (It cannot be VS 2005). The cheapest is
VB.Net
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"refdk" <fuhlendorf@.gmail.com> wrote in message
news:1140804364.362272.141300@.z34g2000cwc.googlegroups.com...
> What is the minimum requirement or version of Visual Studio.NET
> necessary for editing reports when running Reporting Services. I am
> running on a SQL 2000 sp3 and Windows 2003 server.
>|||Thanks, I will try that :-)
/Ren=E9

Minimal configuration of .NET Visual Studio

Hi
What is a minimal configuration of .NET Visual Studio to setup Reporting
Service?
Regards,
GennadiWhat is needed is the 2003 IDE shell.
Visual Basic.NET 2003 version should be enough.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Gena" <gretchkosiy@.hotmail.com> wrote in message
news:uJQ0PpkiEHA.3148@.TK2MSFTNGP10.phx.gbl...
> Hi
> What is a minimal configuration of .NET Visual Studio to setup Reporting
> Service?
> Regards,
> Gennadi
>|||Thanx
Is there any possibilities to run away from .NET VisualStudio to create
reports? I mean any GUI tools.
Thanx
Gennadi
"Lev Semenets [MSFT]" <levs@.microsoft.com> wrote in message
news:uzSqmxkiEHA.1764@.TK2MSFTNGP10.phx.gbl...
> What is needed is the 2003 IDE shell.
> Visual Basic.NET 2003 version should be enough.
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Gena" <gretchkosiy@.hotmail.com> wrote in message
> news:uJQ0PpkiEHA.3148@.TK2MSFTNGP10.phx.gbl...
> > Hi
> >
> > What is a minimal configuration of .NET Visual Studio to setup Reporting
> > Service?
> >
> > Regards,
> > Gennadi
> >
> >
>|||Report Designer is implemented as VS component and would not work without
VS.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Gena" <gretchkosiy@.hotmail.com> wrote in message
news:%23mwUt5kiEHA.3664@.TK2MSFTNGP11.phx.gbl...
> Thanx
> Is there any possibilities to run away from .NET VisualStudio to create
> reports? I mean any GUI tools.
> Thanx
> Gennadi
> "Lev Semenets [MSFT]" <levs@.microsoft.com> wrote in message
> news:uzSqmxkiEHA.1764@.TK2MSFTNGP10.phx.gbl...
>> What is needed is the 2003 IDE shell.
>> Visual Basic.NET 2003 version should be enough.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>> "Gena" <gretchkosiy@.hotmail.com> wrote in message
>> news:uJQ0PpkiEHA.3148@.TK2MSFTNGP10.phx.gbl...
>> > Hi
>> >
>> > What is a minimal configuration of .NET Visual Studio to setup
>> > Reporting
>> > Service?
>> >
>> > Regards,
>> > Gennadi
>> >
>> >
>>
>

Mimic SQL Server Management Studio behavior inside RS Report

I want to know how to mimic the SSMS behavior inside an Reporting Services report when querying an XML field.

In SSMS, a field that is XML shows up as a link, and when the use clicks on the XML, it opens then entire XML document in a new window. I need this exact behavior in RS, but can't accomplish it.

Any smart people out there who can do this?

You would need to use a drillthrough or hyperlink action in the report. You could pass the value of the XML to the target URL.|||

Brian, thats the part that I dont understand. The target isn't in a file- it's in a field in the database. So, with one hyperlink action how do I extract the data, and present it in another IE window, formatted as XML (i.e. indentation, Expand/collapse nodes functionality, etc. like in IE or SSMS)

You say "pass the value of the XML". How do I construnct the hyperlink to do that? Just assign the field to the Drill to URL action? That seems to easy, but I'll give it a shot...

-Kory

|||

I didn't realize you were trying to get an interactive representation of the XML. You can't really accomplish what you want in a report as we don't deal with XML data hierarchically - the XML data extension will flatten it and the binding it into a textbox will simply display the string. (Native XML support is in the long term plans)

So, if you want an interactive view, I would create an ASPX page that took the XML data as a parameter and displayed the HTML then create a URL action to point to the page.

Migration from DTS to SSIS

Hi everybody,

I would REALLY appreciate it if some had a link to a good tutorial about migration from DTS to SSIS, but without visual studio . net.

For example I need to use DTS package in sql server 2005 and execute them, I used migration wizard (SQL 2005) but it didn't work because i have in my computer sql 2000 et sql 2005 and the server name is PC2, however when i use the server source PC2 and the server destination PC2 an error message appear "server destination should be a sql server 2005 instance ".

help me please..

Thanks very much anyone response my question.

Moving to the SSIS 2005 forum from the SSIS 2008 forum.|||

If the connection is to a computer with both 2000 and 2005 on it, the 2005 install needs to be referenced by the server and instance name (MACHINENAME\INSTANCENAME).

Migration from DTS to SSIS

Hi everybody,

I would REALLY appreciate it if some had a link to a good tutorial about migration from DTS to SSIS, but without visual studio . net.

For example I need to use DTS package in sql server 2005 and execute them, I used migration wizard (SQL 2005) but it didn't work because i have in my computer sql 2000 et sql 2005 and the server name is PC2, however when i use the server source PC2 and the server destination PC2 an error message appear "server destination should be a sql server 2005 instance ".

help me please..

Thanks very much anyone response my question.

Moving to the SSIS 2005 forum from the SSIS 2008 forum.|||

If the connection is to a computer with both 2000 and 2005 on it, the 2005 install needs to be referenced by the server and instance name (MACHINENAME\INSTANCENAME).