Can I Have Warm Stand By On SQL 2000

Aug 6, 2001

Can I have warm stand by database on SQL 2000 Server.The source server will be SQL 7.0.
In another words can i shipp transaction logs from SQL 7.0 and make Warm stand by on SQL 2000 with SQL 7.0 full and transaction log backups
Thanks
Mike

View 1 Replies


ADVERTISEMENT

Microsoft SQL Server 2000 Can't Stand Up After Change Administrator Password?!?!

Jul 20, 2005

HI!I have a little problem:I have change the administrator password (Windows 2003 Server) which MSSQL 2000 use to login.And now the SQL server can't stand up.What should I do?thx!gicio--Posted via http://dbforums.com

View 1 Replies View Related

SQL 7.0 Warm Backups ..

Aug 15, 2000

Any one know of a good way to automate the warm backup process ...

I currently load the full DB dump from the night before and then load TLogs ...

Just curious if anyone has this automated

View 1 Replies View Related

Warm/hot Standby

May 16, 2000

We are planning to provide a disaster recovery facility for a production system. Clustering has been ruled out for technical reasons so we are considering either transactional replication or Log shipping.

Microsoft suggested the log shipping option but it seems a bit messy to me and only provides a warm standby in that it only copies log backups to the secondary machine.

Any ideas why log shipping was suggested in preference to transactional replication? Anyone have any experience in this area?

TIA Colin.

View 1 Replies View Related

Warm Backup

Dec 1, 1999

i have two servers Production and Waiting, the waiting is a Fall back server and is in another state but in the same domain, is it possible to to use dump statement to dump database and transaction logs to the waiting server??

View 1 Replies View Related

Warm Standby

Nov 6, 2001

I have inherited a problem that I am hoping someone can help out with. A developer used a perl script to move some backup files from one server to another and then restore the databases on other server (at least we think that is what happened, no one is really sure at this point)

Now I need to take the databases ourt of read only mode and drop them but I get an error 5063 stating that the database is in warm standby and the alter database and sp_dboption statements both fail.

How do I get the databases out of warm standby mode?

Thanks in advance for any help you all can provide.

Brad

View 3 Replies View Related

Warm Backup Problem

Dec 3, 1999

i've disided to use a standby server, i have succeeded in running a schedulled task to dump the transcation log every hour the production server unto the waiting server, my problem is that i cannot run a schedulled task to restore the database on the waiting sever every hour any ideas what i might be doing wrong??

View 2 Replies View Related

ATM Circuit & Sql 70 Warm Backup Servers

Apr 10, 2000

Hello out there.

I am currently testing the transmission rates of sql server 70 backups over an ATM circuit (T3) from tampa, fl to detroit. We are evaluating what we need to do to relocate our warm backup database servers to our Disaster Recovery site in detroit. I have tried several types of transmissions and are not receiving any transfer rates that will reasonably work with a recovery plan. I have tried copying a file from source to target, I have tried backing up from source to target, I have tried FTP'ing files, and never can achieve higher transmission rate then 1 gig per hour.

I am looking to talk to anyone out there that may have implemented a long distance sql servber DR site or anyone who is thinking about it. Or anyone who has any input on how I might be able to achieve a higher transmission rate over a T3. Or anyone who is using SAN's in both their local and DR site and might be using special synchronizing software. I am currently piloting a Metastore SAN and a Compaq SAN to solve some local disk management problems and eventually transmit data from SAN to SAN for DR.

Please, if you are involved with any of these strategies and would like someone to share your knowledge with or if I can be of help to you by sharing our testing knowledge, please write asap.

Thanks.
Gail Wade
Database Administration
Raymond James Financial
gwade@it.rjf.com

View 3 Replies View Related

How To Bring Up Warm Stabdby Server?

Sep 25, 2007

Hello, everyone:

I am making disaster recovery plan and considering technical details. My question is that if I configure log shipping and primary server is failed. I have to bring up secondery server online. As warm standby server, the secondary server is Read-only. How to disable read-only?

Thanks

ZYT

View 3 Replies View Related

Read-only And Warm Standby Status

May 4, 2004

Hi,
I have one database with read-only status. I tried to change it back to normal by doing this..
EXEC sp_dboption 'test', 'read only', 'FALSE' by doing this i'm getting this
Changes to the state or options of database 'test' cannot be made at this time. The database is in single-user mode, and a user is currently connected to it.
And when i tried on Enterprise Manager it is saying
Error 5063 database 'test' is in warm Standby.
I cross checked and confirmed that it is not in single-user mode and no one is connected to the database!!
Any help is greately appreciated.
thanks
ss

View 5 Replies View Related

ActiveX To Warm Up Report Server ?

Mar 21, 2007

Because the IIS threads are recycled at night, the first user that calls up Report Manager in the morning has to wait 30 seconds before the page loads, as IIS is creating a thread.

I'd like to set up a job in SQL Agent that will navigate to http://localhost/reports/ every morning before users come in to work, so they won't have to wait.

I think a SAL Agent job of type ActiveX Script would be suitable for this, so I need to write the code to navigate to the reports page in VBScript.

Anyone knows how to navigate to a page in VBScript ?

tia.

View 4 Replies View Related

SQL Server - Warm Standby Using Transaction Logs

Aug 3, 1999

I have been asked to implement a Warm Standby using Transaction Logs on our main SQL Database - Version 6.5.

Can anyone give assistance regarding scripts, etc., which control the process.

Any assistance is much appreciated.

Regards,

Ian

View 1 Replies View Related

SQL Server 2005 License For Warm Standby

May 9, 2007

I have one cluster (two machines) of sql server 2005 active/passive called "ClustA" with one Ent. server edition license and another separate server called "STDA" as warm standby server for "ClustA".



Do I need SQL Server license for server "STDA"?



Thanks

View 1 Replies View Related

Stand-alone DTS

May 23, 2005

I need to be able to run a DTS package from a computer that doesn't have any SQL tools on it.  What do I need to copy over to that machine to do so?  dtsrun.exe, dll's, etc.
Thanks

View 3 Replies View Related

RTM : What Does This Stand For?

Jul 30, 1998

In the following, can anyone tell me what RTM Stands for?

Thanks
Tim

""Transfer Manager is not available in B3 but will be for RTM.""

View 1 Replies View Related

What Does RTM Stand For?

Nov 29, 2007

When I check my product level of the SQL server 2005, it says it is "RTM."

What does RTM stand for?

Is this the first release before SP1 and SP2?

View 4 Replies View Related

What Does SQL Stand For???

Nov 9, 2007

What Does the "SQL" Stand for? I am just starting to teach myself Visual Studio Programing and some other applications. I can build any computer system that is out there and I have; So I think it is now time for me to study modern programing.

I started waching the Visual LESSONS, provided by Microsoft and I must say "Programing has come a long way since Micosoft (BASICA) and (DOS)"..... I am very enthusiastic about the new wave Software laguages....

Computing has been my hobby as well as a outstanding educational tool, I feel that what makes it so great is that you can spend all you life working or playing with them and NEVER reach and end.... So as a retired Machine and ToolMaker I will lean a new field at my own pace.... And Who Knows????????????

Thank you All......... ToolMan59........ Long Life And Good Health to All.......

View 4 Replies View Related

What Does N In N'string' Stand For? (was T-sql)

Feb 8, 2005

Folks;
declare @table_name varchar(128)

set @table_name = N'tbl_email_type'

what does N stands for?
Please guide where to find more to learn about in BOL.


Howdy!

View 2 Replies View Related

Can It Be Installed On A Stand Alone PC?

Apr 16, 2007

Hi,

I am new to sql server 2005.. Is it possible to install this on a win xp PC? I tried installing it and when I launch it it asks for a server name..

How do I point it to look in local databases?

Any help on getting started is appreciated..

Thanks

View 1 Replies View Related

PLEASE HELP Aspnet_regsql.exe - What Does It Require To Run Stand-alone?

Mar 27, 2006

Does anyone know what aspnet_regsql.exe requires to run stand-alone? I have to apply the .NET 2.0 Management/Role API to a sql2000 database on a machine that does not have the .net 2.0 framework installed.

View 3 Replies View Related

Migrate From Stand Alone To Clustered.

Apr 17, 2006

Here is the scenario:
We have an existing production non clustered SQL 2000 server instance that we need to migrate to a new clustered SQL 2000 server instance. We need to accomplish this without affecting the FQDN that applications use to call this server. I found this article on a solution to rename the server after an xcopy of the entire db structure. Here is the link http://vyaskn.tripod.com/moving_sql_server.htm. The other issue that we are trying to resolve is the time it takes for the snapshots of replication to run (in our case almost a full day). That is why this approach looked like it may be a good solution for us.


Here is the question:
Is it possible to move our existing database to a new clustered environment without having to change the FQDN that other applications use to access this database and without having to reinitialize replication?

View 1 Replies View Related

Stand Alone Connection Issue

Jul 16, 2004

I have a sql server db that works fine when I connect via the internet and from the network, but when I try to connect after disconnecting from the network it doesn't find the database (even though the sql server db is on the machine I am using after disconnecting, of course).

Is there something wrong with my connection string? Could it be the Windows/SQL Server/Mixed Authentication mode?

Maybe the best question I could ask is, if I want to run sql server as a web back-end, as a network utility, and as a local db for a windows app, how should I have it set up from a security/authentication standpoint?

Thanks!

View 1 Replies View Related

How Bring STAND BY To ACTIVE

Jul 15, 2006

Hi all

My management ask me use logshipping in the part of Disaster Recovery plan,as per i know i have put target database in STAND BY mode in logshipping
if ACTIVE MODE fail's how can i bring back the logshipped DB to active


Thanks in Advance
saivyshnav

saivyshnav
Junior DBA

View 9 Replies View Related

SQL 2005 Stand Alone To Cluster

Feb 11, 2007

Our production server is currently running SQL 2005 on a stand alone machine. SQL Server is installed as a default instance. 

 Can we upgrade to a cluster without having to change the instance name i.e currently applications connect to this server with hostname of the server i.e SERVERA, can we install a cluster such that sql server can still be called SERVERA.

 

 

View 6 Replies View Related

Coding C# Stand Alone App With Db (noob)

Nov 3, 2007

Hi everyone!

I'm currently working on an application that needs to store address information.
I figured a database of some sort would be the perfect thing to use.

The thing is:
The application will work locally, there will be no server running on a network

There shouldn't be any login and password protection for the db
When I later on install the application on a computer, a fresh and clean db should be created within the applications folde

How can I create and access a db like that using c# and MS SQL Server?

Any hints, tips, example code, links...anything?


Many thanks in advance!!!


PS. I've been working some with visual c# express and recently installed SQL Server & Manager. I've previusly made some php web pages using MySQL but I´m a total noob when it comes to working with SQL and c# (= I'm stuck!).

View 5 Replies View Related

Installing SQL7 On A Stand Alone NTWorkStation

May 1, 1999

Are there any well known articals/sites on this topic?

View 1 Replies View Related

Stand-alone Run-time Version Of SQL Server 7.0?

Nov 18, 1998

Can SQL Server 7.0 be installed on a laptop as a stand-alone run-time application (using a VB front-end application)? Is it necessary to use MS Access as a gateway, or can SQL Server 7.0 really stand on its own?

View 1 Replies View Related

Migrating Everything From Stand Alone Box To A Cluster Server.

Mar 3, 2004

Can anyone tell me how to migrate everything from a stand alone sql server to a new clusterd environment?

1. Master
2. Msdb
3. Model
4. Jobs
5. DTS packages
6. Logins etc.

P.S. I need to move everything from stand alone to cluster.

Can any one tell best way for each of these?

Thanks,

View 2 Replies View Related

Need Help In Restore Process For Stand By Server

May 29, 2002

Hello everybody .
I have 40 GB db running mostly transaction processing.
I set up
1. back full backup 2 times a day (takes 30 -40 min)
2. log backup every 15 min
3. custom log shipping
4. We don't won't use Cluster.

Once in while becouse of nethwork, or other problem log shipping fails,
so I have to restart log shipping all over starting from restore in stand by mode last full back of my db.IT takes 2-3 hrs just to do this restore !!!

1. So I am asking advice is any way I do restore in less time ?
2. Should diffrential backup be taken ?
3. We will not use Custer

Alex

View 2 Replies View Related

MSSQL Stand By Server Using Replication

Sep 28, 2004

Hi
How to use replication to implement a stand by server in MS SQL
Thanks in advance
Murali

View 1 Replies View Related

SQL 2012 :: MSDTC On Stand Alone Servers

May 28, 2015

Does MSDTC auto-install with the plain vanilla version of SQL Enterprise? Or do I have to install it later?Do you know of any links that reference specifically SQL 2012 stand-alone server installs of MSDTC?

View 0 Replies View Related

Stand Alone Client Tools Installation

Jul 23, 2005

Hi,I'm looking for stand alone installation for SQL server Client tools,or the files required for creating such an installation. I would liketo include this installation as part of the setup for my ownSQL-dependant app. Any assistance would be greatly appreciated.

View 3 Replies View Related

DTS_E_PRODUCTLEVELTOLOW - Migrating From Stand Alone To Cluster

Dec 27, 2007

I am having the following problems and scenarios.

I am moving all of our SSIS packages from a stand alone server to a clustered environment. The old server ran Enterprise Edition, the new server runs Enterprise Edition 64 bit.

One package on the new server is giving me the error messaage DTS_PRODUCTLEVELTOLOW when run from a job. The package is stored in MSDB

I went back to the server and ran the following with the following results.

- Connected to SSIS from Management Studio on my desktop and ran the package and got the same error message.

- Did the same as above but was connected to the server through Remote Desktop and it ran fine

- Ran the job, which just runs the package and it ran fine


On the new server it won't run in any scenario.



Any ideas on what to do?

Thanks

View 8 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved