0
votes
1answer
82 views

Transactional Replication from SQL Server 2008 to 2000

I has transactional replication from my server1 (MS SQL 2000) to server2 (MS SQL 2000) in another company (and on different network) and it worked OK. Instead of using real name of server2, I used ...
0
votes
2answers
116 views

Synch SQL 2008 with failover server?

Currently they have a single SQL 2000 Std install on a server that needs to be retired. They run an app in terminal services to manipulate the data. So I'm looking at two new servers with SQL 2008 ...
2
votes
2answers
99 views

Backwards-compatible (to SQL 2000) server version and compatibility version check

I have a script which uses features not present in SQL Server 2000. Specifically, the script creates a stored procedure which uses a data type added in SQL Server 2005. I need to use conditional ...
2
votes
1answer
136 views

Restore sql server 2000 database to 2008

I am not a DBA. I will be doing this for the first time. So I am not sure what all I am supposed to do? I will be restoring sql server 2000 database to sql server 2008. Are there anywhere step by ...
1
vote
5answers
2k views

Best way to improve disk performance (SQL Server 2000)

I am having some disk access issues on a web application. The main load is many concurrent inserts/updates/selects on large tables. It is currently a single 2ru rackmount running SQL Server 2000 and ...
0
votes
2answers
430 views

Connectivity with SQL Server Express 2008 r2 and SQL Server 2000 on same machine

At first glance this may same a duplicate of Installing both SQL Server 2000 and SQL Server 2008 on the same machine, but it is not. I have SQL Server 2000 and SQL Server 2008 R2 installed on the ...
2
votes
2answers
358 views

Benchmark tests for MSSQL 2000 VS MSSQL 2008.. (thinking for upgrade)

How much of a difference will there be (for speed and other benchmark results) for a database about 5 and even 10 GB to move from MSSQL 2000 to MSSQL 2008? It's running on a Windows 2003 VMWare guest ...
1
vote
3answers
68 views

Backing Up Transaction Logs to Tape?

I'm about to put my database in Full Recovery Model and start taking transaction log backups. I am taking a full nightly backup to another server and later in the evening this file and many others are ...
0
votes
1answer
3k views

Replication between SQL 2008 & SQL 2000 - Across network (DMZ) - process could not connect to Subscriber

I have 2 servers... OTTO is located on site, and connected to domain It is running SQL 2008. I have created the database, in SQL 2000 compatability mode. WEBDB3 is located in datacenter, not ...
1
vote
2answers
3k views

SQL Backup - Restoring to different data / log files - Changing file structure…?

I'm trying to restore a BAK of a database we have, onto new, better hardware. Here is a screenshot of the UI in Management Studio http://twitpic.com/wmtr8/full The existing db has an mdf, and ndf ...
1
vote
0answers
2k views

SQL Server 2008 database - Running in 2000 Compatibility mode…?

I have an application that currently runs on SQL 2000, on a server with Windows 2000. The hardware has just about run out of useful life - HD's are almost full, more users than 2gb ram can cope with ...
0
votes
1answer
1k views

Installing both SQL 2000 and SQL 2008 on the same machine

Is it possible to install BOTH 2000 and 2008 on the same machine (and have them as different instances) Ideally, I want the 2008 to be default instance, with 2000 named "legacy" or something... We ...
2
votes
5answers
1k views

How to install SQL Server 2000, SQL Server 2005 and SQL Server 2008 on a single machine

I'm in the process of migrating development databases from an old (soon to be decommissioned) database server to a VMWare-hosted virtual machine running Windows 2008 x64. The old server runs SQL ...
0
votes
5answers
565 views

Improvement (not new) Features Between SQL Server 2005 and 2008

Here are the givens: you are going to want to scream about this question this is an Oracle shop and will continue to be all current environments are MSSQL 2000 Standard Edition the answer(s) will ...
0
votes
2answers
442 views

SQL 2008 Replication corrupt data problem

We took a SQL 2000 database. Took a lightspeed backup. Restored on SQL 2008 active/passive cluster. Then setup replication to replicate the data back to SQL 2000. So 2008 is the publisher/distributor, ...
1
vote
1answer
941 views

Scripting MS SQL Server 2000/2008 Roles

I'm currently migrating a MS SQL Server from 2000 to 2008. I really want to migrate all of the roles (including all members and permissions of that role) from the 2000 box by scripting them. Then, on ...
1
vote
6answers
1k views

Is it possible to change all users passwords to upper-case

I'm currently migrating some servers from MS sql server 2000 to 2008. Some of the legacy apps are password protected by essentially checking if a user with that name and password exists on the server. ...
6
votes
4answers
17k views

SQL Server 2Kx: How to move a database to a different partition in the local file system?

SQL Server creates its databases in the system program files directory structure. I want to separate the database files away from the system partition. Assuming the database is already created and ...