database 'master4IDR' in load msg in log

I am seeing the message 'bypassing recovery of database master4IDR because it is marked IN LOAD' in my sql log. But I have not restored any of the sys dbs. The msg is appearing every day, but everything else seems to be fine.

What is causing it? Should I worry about it ? (I do) and what can I do about it?

I just searched a bit and found this discussion:

http://www.sqlteam.com/Forums/post.asp?method=ReplyQuote&REPLY_ID=162149&TOPIC_ID=48723&FORUM_ID=6

From this post:

"I found that the model4IDR thing is the database created by Veritas BackExec which has the Interlligent Disaster Recovery option. The Veritas backup process will use these databases during backup. "

Thanks,
Sam Lester (MSFT)

database 'master4IDR' in load msg in log

I am seeing the message 'bypassing recovery of database master4IDR because it is marked IN LOAD' in my sql log. But I have not restored any of the sys dbs. The msg is appearing every day, but everything else seems to be fine.

What is causing it? Should I worry about it ? (I do) and what can I do about it?

I just searched a bit and found this discussion:

http://www.sqlteam.com/Forums/post.asp?method=ReplyQuote&REPLY_ID=162149&TOPIC_ID=48723&FORUM_ID=6

From this post:

"I found that the model4IDR thing is the database created by Veritas BackExec which has the Interlligent Disaster Recovery option. The Veritas backup process will use these databases during backup. "

Thanks,
Sam Lester (MSFT)

Database Logon problem Crystal Report

I am using following code in form load.
it works fine on one PC but when i run the same application on other pc with different version of Windows Xp it is asking for database logon for report.

I did tried using my provided login info using code but it is executing front end query as well as query in the report.

Any Suggestions will be appreciated.
Thanks in advance



ConnStr = "PROVIDER=MSDAORA.1;PERSIST SECURITY INFO=FALSE;USER ID=scott;PASSWORD=tiger;DATA SOURCE=orcl"
conObj = New OleDbConnection(ConnStr)

strsql = "select * from emp"

cmdObj.Connection = conObj

cmdObj.CommandText = strsql

daObj.SelectCommand = cmdObj

daObj.Fill(dsObj, "test")

rptDoc.Load("\\server\reports\abc.rpt")

srcCr = rptDoc

srcCr.SetDataSource(dsObj)

CRV.ReportSource = rptDoc

CRV.Show()i used CR viewer of CR XI ,it solved the problem. other system had cr viewer 9.5

Database load testing

I am trying to use "TraceReplay" to replay a trace captured by the SQL Server Profiler. I can replay the tracefile using a normal windows application, but I need to get it working with a unit test so that I can simulate user load on the DB server.

This is the first erro i get :-

The assembly named 'pfclnt90' was loaded from 'file:///C:/Program Files/Microsoft SQL Server/90/Tools/Binn/pfclnt90.dll' using the LoadFrom context. The use of this context can result in unexpected behavior for serialization, casting and dependency resolution. In almost all cases, it is recommended that the LoadFrom context be avoided. This can be done by installing assemblies in the Global Assembly Cache or in the ApplicationBase directory and using Assembly.Load when explicitly loading assemblies.

Followed by

The assembly with display name 'pfclnt90' failed to load in the 'Anonymous' binding context of the AppDomain with ID 1. The cause of the failure was: System.IO.FileNotFoundException: Could not load file or assembly 'pfclnt90, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
File name: 'pfclnt90, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'

=== Pre-bind state information ===
LOG: User = BTWEB\sxs24
LOG: DisplayName = pfclnt90, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
(Fully-specified)
LOG: Appbase = file:///C:/Program Files/Microsoft Visual Studio 8/Common7/IDE/
LOG: Initial PrivatePath = NULL
Calling assembly : (Unknown).
===
LOG: This bind starts in default load context.
LOG: Using application configuration file: C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\vstesthost.exe.config
LOG: Using machine configuration file from C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\config\machine.config.
LOG: The same bind was seen before, and was failed with hr = 0x80070002.

I deploy the 'pfclnt90.dll' into the "out" directory but this does not seem to have fixed the problem. Also, If I add 'pfclnt90 to the GAC, the test fails source.InitializeAsReader("C:\\input.trc");

I have included my source below.

Code Snippet

publicvoid go()

{

TraceReplay replay = newTraceReplay();

TraceFile source = newTraceFile();

source.InitializeAsReader("C:\\input.trc");

replay.Source = source;

SqlConnectionInfo connection = newSqlConnectionInfo();

connection.ServerName = "server";

connection.UseIntegratedSecurity = true;

replay.Connection = connection;

replay.Start();

}

Moved this post to the SQL Server SMO / DMO forum (I hope this is the right forum for this question).

database load balancing using sql clustering

can sql server 2000 database load balancing be achived by using sql clustering?
Say an active/active/passive type set up?
Thank you.
No, clustering is a hardware fail over solution only. There are no true
load balancing solutions for sql server at the moment. If you had strictly
read only data you could use NLB to point to multiple servers but falls
apart when you get into updates and such. You can use Distributed
Partitioned Views across servers but it has nothing to do with clustering
and is still not a true load balancing solution. SQL Server works best as a
scale up solution not a scale out.
Andrew J. Kelly SQL MVP
"RobinMC" <RobinMC@.discussions.microsoft.com> wrote in message
news:F09CE8B4-4140-441E-A801-038AB6B34DFD@.microsoft.com...
> can sql server 2000 database load balancing be achived by using sql
clustering?
> Say an active/active/passive type set up?
> Thank you.
|||With SQL 2000 clustering each instance runs on a single machine, so the
Databases are not load balanced in any way.
You can A/A/P cluster, but each server would have its own instance or two.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
"RobinMC" <RobinMC@.discussions.microsoft.com> wrote in message
news:F09CE8B4-4140-441E-A801-038AB6B34DFD@.microsoft.com...
> can sql server 2000 database load balancing be achived by using sql
clustering?
> Say an active/active/passive type set up?
> Thank you.