MSDE 7.0 and SQL2000

Can you install SQL2000 on a server with an application
that is using MSDE 7.0 which was installed with the
software ?
If you can, what is the best way to do so without it
affecting the previous installation of MSDE 7.0 ?Yes you can. BE aware, though, that MDAC on the machine will be upgraded to 2.6 (if not or higher
already), so make sure you test the app for that MDAC version.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Valencia" <vahorda@.hotmail.com> wrote in message news:a86f01c3ebb2$9d88f350$a401280a@.phx.gbl...
> Can you install SQL2000 on a server with an application
> that is using MSDE 7.0 which was installed with the
> software ?
> If you can, what is the best way to do so without it
> affecting the previous installation of MSDE 7.0 ?
>|||Thank you Tibor. I checked the version of MDAC and it is
2.5.
>--Original Message--
>Yes you can. BE aware, though, that MDAC on the machine
will be upgraded to 2.6 (if not or higher
>already), so make sure you test the app for that MDAC
version.
>--
>Tibor Karaszi, SQL Server MVP
>Archive at: http://groups.google.com/groups?
oi=djq&as_ugroup=microsoft.public.sqlserver
>
>"Valencia" <vahorda@.hotmail.com> wrote in message
news:a86f01c3ebb2$9d88f350$a401280a@.phx.gbl...
>> Can you install SQL2000 on a server with an application
>> that is using MSDE 7.0 which was installed with the
>> software ?
>> If you can, what is the best way to do so without it
>> affecting the previous installation of MSDE 7.0 ?
>
>.
>sql

MSDE 7.0 and SQL2000

Can you install SQL2000 on a server with an application
that is using MSDE 7.0 which was installed with the
software ?
If you can, what is the best way to do so without it
affecting the previous installation of MSDE 7.0 ?Yes you can. BE aware, though, that MDAC on the machine will be upgraded to
2.6 (if not or higher
already), so make sure you test the app for that MDAC version.
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ls
erver
"Valencia" <vahorda@.hotmail.com> wrote in message news:a86f01c3ebb2$9d88f350$a401280a@.phx.gbl...[Q
UOTE]
> Can you install SQL2000 on a server with an application
> that is using MSDE 7.0 which was installed with the
> software ?
> If you can, what is the best way to do so without it
> affecting the previous installation of MSDE 7.0 ?
>[/QUOTE]|||Thank you Tibor. I checked the version of MDAC and it is
2.5.
>--Original Message--
>Yes you can. BE aware, though, that MDAC on the machine
will be upgraded to 2.6 (if not or higher
>already), so make sure you test the app for that MDAC
version.
>--
>Tibor Karaszi, SQL Server MVP
>Archive at: http://groups.google.com/groups?
oi=djq&as_ugroup=microsoft.public.sqlserver
>
>"Valencia" <vahorda@.hotmail.com> wrote in message
news:a86f01c3ebb2$9d88f350$a401280a@.phx.gbl...
>
>.
>

MSDE & SQL2000

I am developing a Crystal Reports App in VS2005 (VB). I was originally working on an XP machine with MSDE and stored procedures where it worked fine.

I then transferred the development to a Win2003 machine with SQL2000 and am now getting the following error;

Failed to open a rowset. Description: 'Get_Calls_By_MLO_Date' expects parameter '@.DT1' which was not supplied. Plus some other error detail.

Here is the SP.

CREATE PROCEDURE Get_Calls_By_MLO_By_Date
@.DT1 datetime,
@.DT2 datetime
AS
SELECT MLO, CallNo, DT, Type FROM Actions
WHERE dt >= @.DT1 AND dt <= @.DT2 AND ActionID=1ORDER BY MLO, DT
GO

If I transfer everything back to the XP machine it works fine.

Any ideas?

Thanks

Terry.

How did you call the stored procedure that causes the error?|||

Hi,

It's called from the Crystal Report object. The function below accepts 2 parameters; 1. The report viewer and 2. (optional) a hashtable with the key/value pairs being the parameter info e.g. Key=@.DT1, Value = 13/01/2006 12:00:01 AM

As I mentioned in the original post, this works fine on the XP box but not the Win2003. The are a number of reports; some accept parameters (all of which appear to fail with the same error) and others that don't, all of which work as expected. Other than the OS, and SQL as opposed to MSDE the only other differerence I can think of is the copy of VS2005.

Thanks.

Private Function LoadReport(ByVal ReportNameAs String, _ByVal ViewerAs CrystalDecisions.Windows.Forms.CrystalReportViewer, _Optional ByVal ParametersAs Hashtable =Nothing)As Boolean Dim rptAs New ReportDocumentDim pvCollAs New CrystalDecisions.Shared.ParameterValues' Objects used to set the proper database connection informationDim tbCurrentAs CrystalDecisions.CrystalReports.Engine.TableDim tliCurrentAs CrystalDecisions.Shared.TableLogOnInfoDim pdValAs New CrystalDecisions.Shared.ParameterDiscreteValueTry Dim appPathAs String = Application.ExecutablePath appPath = appPath.Substring(0, appPath.LastIndexOf("\") + 1)Dim fileExistsAs Boolean = false fileExists = My.Computer.FileSystem.FileExists(appPath &"Reports\" & ReportName)If fileExistsThen rpt.Load(appPath &"Reports\" & ReportName)Else MsgBox("Cannot locate report file", MsgBoxStyle.Critical,"Load Error")     pvColl =Nothing    pdVal =NothingExit Function End If For Each tbCurrentIn rpt.Database.Tables tliCurrent = tbCurrent.LogOnInfoWith tliCurrent.ConnectionInfo .ServerName = ServerName .UserID ="" .Password ="" .DatabaseName = My.Settings.DBName.ToStringEnd With tbCurrent.ApplyLogOnInfo(tliCurrent)Next tbCurrentIf Not IsNothing(Parameters)Then Dim myEnumAs IDictionaryEnumerator = Parameters.GetEnumeratorWhile myEnum.MoveNext pvColl.Clear() pdVal.Value = myEnum.Value pvColl.Add(pdVal) rpt.DataDefinition.ParameterFields(myEnum.Key).ApplyCurrentValues(pvColl)End While End If Viewer.ReportSource = rptCatch ExpAs LoadSaveReportException MsgBox("Report " & ReportName &" not found.", _ MsgBoxStyle.Critical,"Load Report Error")Catch ExpAs Exception MsgBox(Exp.Message, MsgBoxStyle.Critical,"General Error")Finally pvColl =Nothing pdVal =Nothing End Try End Function

|||

Thanks for the help. The problem is a crystal reports one and is detailed here

http://support.businessobjects.com/library/kbase/articles/c2017367.asp

MSDE

We are running MSDE on Windows 2000 Server. The version number SQL2000,
8.00.760, 5.2 (Build 3790:SP1). So, I am running SP3. Is it necessary to
apply SP3a? If it is, is the "SP3a" file the same running on both SQL 2000
and MSDE? Thanks.It says here its not necessary unless you want the new "disable network
protocols" option.
http://www.microsoft.com/downloads/...&displaylang=en
Also note SP4 is available.
http://www.microsoft.com/downloads/...&displaylang=en
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"Diane Walker" wrote:
| We are running MSDE on Windows 2000 Server. The version number SQL2000,
| 8.00.760, 5.2 (Build 3790:SP1). So, I am running SP3. Is it necessary
to
| apply SP3a? If it is, is the "SP3a" file the same running on both SQL
2000
| and MSDE? Thanks.
|
||||Thank you very much, Dave.
"Dave Patrick" <DSPatrick@.nospam.gmail.com> wrote in message
news:OaYOqyQ9GHA.3736@.TK2MSFTNGP02.phx.gbl...
> It says here its not necessary unless you want the new "disable network
> protocols" option.
>
http://www.microsoft.com/downloads/... />
laylang=en
> Also note SP4 is available.
>
http://www.microsoft.com/downloads/... />
laylang=en
>
> --
> Regards,
> Dave Patrick ...Please no email replies - reply in newsgroup.
> Microsoft Certified Professional
> Microsoft MVP [Windows]
> http://www.microsoft.com/protect
> "Diane Walker" wrote:
> | We are running MSDE on Windows 2000 Server. The version number SQL2000,
> | 8.00.760, 5.2 (Build 3790:SP1). So, I am running SP3. Is it
necessary
> to
> | apply SP3a? If it is, is the "SP3a" file the same running on both SQL
> 2000
> | and MSDE? Thanks.
> |
> |
>|||You're welcome.
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"Diane Walker" wrote:
| Thank you very much, Dave.

MSDE

We are running MSDE on Windows 2000 Server. The version number SQL2000,
8.00.760, 5.2 (Build 3790:SP1). So, I am running SP3. Is it necessary to
apply SP3a? If it is, is the "SP3a" file the same running on both SQL 2000
and MSDE? Thanks.
It says here its not necessary unless you want the new "disable network
protocols" option.
http://www.microsoft.com/downloads/d...displaylang=en
Also note SP4 is available.
http://www.microsoft.com/downloads/d...displaylang=en

Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"Diane Walker" wrote:
| We are running MSDE on Windows 2000 Server. The version number SQL2000,
| 8.00.760, 5.2 (Build 3790:SP1). So, I am running SP3. Is it necessary
to
| apply SP3a? If it is, is the "SP3a" file the same running on both SQL
2000
| and MSDE? Thanks.
|
|
|||Thank you very much, Dave.
"Dave Patrick" <DSPatrick@.nospam.gmail.com> wrote in message
news:OaYOqyQ9GHA.3736@.TK2MSFTNGP02.phx.gbl...
> It says here its not necessary unless you want the new "disable network
> protocols" option.
>
http://www.microsoft.com/downloads/d...displaylang=en
> Also note SP4 is available.
>
http://www.microsoft.com/downloads/d...displaylang=en
>
> --
> Regards,
> Dave Patrick ...Please no email replies - reply in newsgroup.
> Microsoft Certified Professional
> Microsoft MVP [Windows]
> http://www.microsoft.com/protect
> "Diane Walker" wrote:
> | We are running MSDE on Windows 2000 Server. The version number SQL2000,
> | 8.00.760, 5.2 (Build 3790:SP1). So, I am running SP3. Is it
necessary
> to
> | apply SP3a? If it is, is the "SP3a" file the same running on both SQL
> 2000
> | and MSDE? Thanks.
> |
> |
>
|||You're welcome.
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"Diane Walker" wrote:
| Thank you very much, Dave.

MSDE

I have MSDE Deployment Kit with my SQL2000 CD.
But while installing it is giving error the name alredy
exists. And also tell me the sourse where i will get
examples and information about MSDE-2000.
Hi Rahul,
The MSDE can be installed multiple times on a single system. These separate
installations are called 'instances'. Each (apart from the default initial
instance) has a name. It is possible the one you are trying to create
already exists.
For info on the MSDE, a very good place to start is
http://www.microsoft.com/sql/msde
HTH,
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Rahul" <superrahul@.hotmail.com> wrote in message
news:be2001c43817$4443bdf0$a001280a@.phx.gbl...
> I have MSDE Deployment Kit with my SQL2000 CD.
> But while installing it is giving error the name alredy
> exists. And also tell me the sourse where i will get
> examples and information about MSDE-2000.
>
|||Can you explain or give a reference for what a XPE runtime image is?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Nigel" <anonymous@.discussions.microsoft.com> wrote in message
news:6DEDC927-7B23-4C28-B0FA-FF3528190688@.microsoft.com...
> Does microsoft or anyone for that matter have a solution for including MSDE in a XPE runtime image?
|||Nigel,
Yes, we have working MSDE component. The component has all necessary dependencies specified and works stable with Minlogon/Winlogon
images.
Regards,
KM,
BSquare Corporation

> Does microsoft or anyone for that matter have a solution for including MSDE in a XPE runtime image?
|||KM,
I am looking at a "Courtesy Copy for Reference Purposes Only" of the "Additional Licensing Provisions for Microsoft Windows XP Embedded Runtime Licenses", Paragraph 12, which states:
"COMPANY may not distribute in any manner, nor include in the Image, (i) the Microsoft Data Engine or (ii) The 'setup.exe' file contained in the SQLMSDE folder."
How can I interepret this paragraph in ANY way that lets me use MSDE in my embedded product?
~Desi
"KM" wrote:

> Nigel,
> Yes, we have working MSDE component. The component has all necessary dependencies specified and works stable with Minlogon/Winlogon
> images.
> --
> Regards,
> KM,
> BSquare Corporation
>
>
>
|||Bump for an unanswered thread...
Microsoft? Anyone?
"Desi Richards" wrote:
[vbcol=seagreen]
> KM,
> I am looking at a "Courtesy Copy for Reference Purposes Only" of the "Additional Licensing Provisions for Microsoft Windows XP Embedded Runtime Licenses", Paragraph 12, which states:
> "COMPANY may not distribute in any manner, nor include in the Image, (i) the Microsoft Data Engine or (ii) The 'setup.exe' file contained in the SQLMSDE folder."
> How can I interepret this paragraph in ANY way that lets me use MSDE in my embedded product?
> ~Desi
>
> "KM" wrote:

MSDE

We are running MSDE on Windows 2000 Server. The version number SQL2000,
8.00.760, 5.2 (Build 3790:SP1). So, I am running SP3. Is it necessary to
apply SP3a? If it is, is the "SP3a" file the same running on both SQL 2000
and MSDE? Thanks.It says here its not necessary unless you want the new "disable network
protocols" option.
http://www.microsoft.com/downloads/details.aspx?familyid=90dcd52c-0488-4e46-afbf-acace5369fa3&displaylang=en
Also note SP4 is available.
http://www.microsoft.com/downloads/details.aspx?familyid=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5&displaylang=en
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"Diane Walker" wrote:
| We are running MSDE on Windows 2000 Server. The version number SQL2000,
| 8.00.760, 5.2 (Build 3790:SP1). So, I am running SP3. Is it necessary
to
| apply SP3a? If it is, is the "SP3a" file the same running on both SQL
2000
| and MSDE? Thanks.
|
||||Thank you very much, Dave.
"Dave Patrick" <DSPatrick@.nospam.gmail.com> wrote in message
news:OaYOqyQ9GHA.3736@.TK2MSFTNGP02.phx.gbl...
> It says here its not necessary unless you want the new "disable network
> protocols" option.
>
http://www.microsoft.com/downloads/details.aspx?familyid=90dcd52c-0488-4e46-afbf-acace5369fa3&displaylang=en
> Also note SP4 is available.
>
http://www.microsoft.com/downloads/details.aspx?familyid=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5&displaylang=en
>
> --
> Regards,
> Dave Patrick ...Please no email replies - reply in newsgroup.
> Microsoft Certified Professional
> Microsoft MVP [Windows]
> http://www.microsoft.com/protect
> "Diane Walker" wrote:
> | We are running MSDE on Windows 2000 Server. The version number SQL2000,
> | 8.00.760, 5.2 (Build 3790:SP1). So, I am running SP3. Is it
necessary
> to
> | apply SP3a? If it is, is the "SP3a" file the same running on both SQL
> 2000
> | and MSDE? Thanks.
> |
> |
>|||You're welcome.
--
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"Diane Walker" wrote:
| Thank you very much, Dave.|||Dave,
Do I need to apply SP3a first before applying SP4 or I can apply SP4 without
applying SP3a first? Thanks.
"Dave Patrick" <DSPatrick@.nospam.gmail.com> wrote in message
news:OaYOqyQ9GHA.3736@.TK2MSFTNGP02.phx.gbl...
> It says here its not necessary unless you want the new "disable network
> protocols" option.
>
http://www.microsoft.com/downloads/details.aspx?familyid=90dcd52c-0488-4e46-afbf-acace5369fa3&displaylang=en
> Also note SP4 is available.
>
http://www.microsoft.com/downloads/details.aspx?familyid=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5&displaylang=en
>
> --
> Regards,
> Dave Patrick ...Please no email replies - reply in newsgroup.
> Microsoft Certified Professional
> Microsoft MVP [Windows]
> http://www.microsoft.com/protect
> "Diane Walker" wrote:
> | We are running MSDE on Windows 2000 Server. The version number SQL2000,
> | 8.00.760, 5.2 (Build 3790:SP1). So, I am running SP3. Is it
necessary
> to
> | apply SP3a? If it is, is the "SP3a" file the same running on both SQL
> 2000
> | and MSDE? Thanks.
> |
> |
>|||No, service packs are cumulative. Each new service pack contains all the
fixes that are in earlier service packs, together with any new fixes. You do
not have to install an earlier service pack before you install the latest
one.
--
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"Diane Walker" wrote:
| Dave,
|
| Do I need to apply SP3a first before applying SP4 or I can apply SP4
without
| applying SP3a first? Thanks.|||Thank you very much again, Dave.
"Dave Patrick" <DSPatrick@.nospam.gmail.com> wrote in message
news:uAgDh$V9GHA.3352@.TK2MSFTNGP03.phx.gbl...
> No, service packs are cumulative. Each new service pack contains all the
> fixes that are in earlier service packs, together with any new fixes. You
do
> not have to install an earlier service pack before you install the latest
> one.
> --
> Regards,
> Dave Patrick ...Please no email replies - reply in newsgroup.
> Microsoft Certified Professional
> Microsoft MVP [Windows]
> http://www.microsoft.com/protect
> "Diane Walker" wrote:
> | Dave,
> |
> | Do I need to apply SP3a first before applying SP4 or I can apply SP4
> without
> | applying SP3a first? Thanks.
>|||You're welcome.
--
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"Diane Walker" wrote:
| Thank you very much again, Dave.

msdb..backupset.backup_finish_date -- changes from SQL2000?

It appears that the behavior has changed for the backupset table in the MSDB database between versions.

In SQL2000 backup_start_date & backup_finish_date were populated correctly. In 2005, backup_finish_date is the same as the backup_start_date value. Is this a bug or should I be looking for my backup timing elsewhere in 2005?

Thank you.

I can't repro the problem. It works fine for me.

I use this query to get a quick look at timings.

select top 100 database_name, backup_set_id, type, backup_finish_date, backup_start_date,
datediff (second,backup_start_date, backup_finish_date) secondsToComplete
,convert (bigint, backup_size / 1048576 ) sizeInMB

from msdb..backupset
where type = 'D'
order by backup_finish_date desc

If you can describe a repro, please let us know.

|||

It appears to work fine for database backups, I see timing differences in them. However for log backups (type = 'L') it appears that it's not changing, but I'm still investigating.

I was originally pursuing a long running t-log backup time and that's how I noticed this behavior. I've since discovered that if a backup device has a large # of backups appended to it, it dramaticly effects the time it takes to perform the backup. I was suprised to find that the finish time was being reported as the same as the start time when it clearly was taking much longer to perform the backup...

Currently (and with a small # of appends), my backups are averaging around 1/10th second so I'll have to try to dummy up some logspace and see if it's just that my backups are running quicker than the process can account for, or if it is indeed a bug.

I'll have more in a day or so once I can get some testing done. Thank you for looking into this.

|||

Your info helps.

Our start/finish times do NOT include the time it takes to open the media set and prepare it for writing.

The time only includes the time that is actually spent transferring data. This is the same logic as exists in sql2000.

For example, it may take many minutes to open a tape drive and seek to the end when appending data. That time is not included.

So if you want to also include that time, you'll need to add your own start/stop time.

This might already work if you use sqlagent jobs, and look up the start/top time in the job history.

Are you backing up to tape? That will always be relatively slow, and gets worse when appending backups.

If you have a lot of backups to append in a batch, such as a nightly job, you can use BACKUP WITH NOREWIND which avoids all the time to REWIND/SEEK to end that happens in such a scenario.

If you are backing up to disk, then having a lot of backups in the file shouldn't really matter...to a point.

1000's of backups WILL result in significant delay. The reason is that when setting up for the backup, we perform a synchronous read of all the marks before/after each backup set.

For disk backups, my recommendation is to prefer the use of a single filesystem directory, then write each backup into a separate disk file. That gives you better control over retention and space management. But I'd agree that it might be slightly more work to wrap this in your backup jobs. If you are using our management tools, they already do this by naming the log backups as ***.TRN where the *** includes the database name and timestamp of the backup.

Hope that helps.

MSDB Database SUSPECT - RESET PROCEDURE ?

I have a regional server running SQL2000 and Merge replication, the MSDB, NORTHWIND and 2 User DB's have been marked suspect. I cannot get into query analyzer etc to run the necessary scripts as it is all suspect.

Any ideas on how I can reset the status on the MSDB database??
Unfortunately there is no backup of either of the 2 system databases :(

** ANY ASSISTANCE WOULD BE GREATLY APPRECIATED **

JReset database with "suspect" status:

Do the following steps from the Query Analyzer:

1) Use Master
GO
EXEC sp_resetstatus <dbname>
2) Stop & Start the SQL Server
3) Run DBCC CHECKDB
4) Do the Full database backup (Master DB included)

If the above steps didn't resolve the problem, run the query below:

Use Master
GO
EXEC sp_configure 'allow updates', 1
GO
Reconfigure with override
GO

Do the step 1 ~ 4 above, then:

Use Master
GO
EXEC sp_configure 'allow updates', 0 -- to turn off
GO
Reconfigure with override
GO

NOTE: If the database become "suspect" because it ran out of disk space, you have to do the step #1 above, then use the "ALTER DATABASE ..." to add more data file (or log file), Stop & start the SQL Server and finish with step #3 & #4 as above.

Good luck.|||Valid reponse by SVT and make sure to have regular backups for SYSTEM Databases too in future.

MSDB and MASTER DB

Im using MS SQL2000 and have and replication scheme with log
shipping. Is posible replicate by log shipping or transactional
replication schemes this DBs
Thanks
I'm not sure what the question is really here - the subject seems so
different to the body text
If you want to know the pros and cons of transactional replication vs log
shipping, please see this article:
http://www.replicationanswers.com/Standby.asp
If you are looking to set up a combination of log shipping and replication,
then please tell us a little more...
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
|||Both system db's are in simple mode. Microsoft recommends backing the msdb
database up and shipping it. While it is possible to restore a master
database to another server, Microsoft recommends you transfer objects to the
standby server.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<gnp1977@.gmail.com> wrote in message
news:1173280868.971366.142840@.c51g2000cwc.googlegr oups.com...
Im using MS SQL2000 and have and replication scheme with log
shipping. Is posible replicate by log shipping or transactional
replication schemes this DBs
Thanks
|||Hi, thanks for the answer, I need transfer the content of two DB to a
standby server...One of this have 35mb and the other have 13GB.
What method is the better? Transactional or Log Shipping?
And other thing, de DBs MASTER and MSDB can be replicated to the
stand by server, I need this because is a Continuity of Bussines site.
Thanks
|||For these volumes I would use transactional replication if possible. For the
master and msdb databases, what sort of objects are you moving?
In master your linked servers and logins live. Do these change much? There
is a SQL DTS/SSIS job which will transfer the logins. Your msdb databsae
will contain DTS packages and jobs. These can be scripted/exported and sent
to the standby server.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<gnp1977@.gmail.com> wrote in message
news:1173296916.452161.294790@.n33g2000cwc.googlegr oups.com...
Hi, thanks for the answer, I need transfer the content of two DB to a
standby server...One of this have 35mb and the other have 13GB.
What method is the better? Transactional or Log Shipping?
And other thing, de DBs MASTER and MSDB can be replicated to the
stand by server, I need this because is a Continuity of Bussines site.
Thanks