Viewing 15 posts - 1,576 through 1,590 (of 2,387 total)
It really surprise me you don't have a test system and why mamagement think it is unnecessary to have one.
June 26, 2003 at 8:49 am
I would try backup it from Query Anazyer and you may see some error message if it fails too. If it runs successfully, I would follow MarkusB suggestion to check...
June 26, 2003 at 8:44 am
Of course, nobody perform the restoration test in their production server.
If you only test the method workable, How are you sure the backup set is restorable if some kind...
June 26, 2003 at 8:07 am
Your SQL Server service account doesn't have to be NT administrator. As long as it has suffiecient privilege as required by installation guide from BOL, your SQL Server will work...
June 26, 2003 at 7:51 am
What error messages did you get? Login with 'sa' privilege to backup it to see whether you still have problem.
June 26, 2003 at 7:34 am
You can install SQL Server as default or named instance. The SQL Server name will be machine name if the installation is default instance, It will be machinename\instance name if...
June 25, 2003 at 2:56 pm
Do you run default instance or named instance in SQL Server 2000?
June 25, 2003 at 1:42 pm
Which account did you use to run DTS package from server console? Is it same as the SQL Server Agent account? Who is the job owner?
June 25, 2003 at 1:28 pm
Read BOL about Upgrading Databases from SQL Server 6.5 (Upgrade Wizard).
June 25, 2003 at 12:57 pm
quote:
The packages runs without error if run in DTS Designer but fails on the first step which uses the Oracle ODBC...
June 25, 2003 at 12:17 pm
It also depends on whether you have downtime, if you do, detach and attach may be the way, otherwise, you need to backup/restore or DTS.
June 25, 2003 at 6:04 am
Assunming you have following table structure and the example may the one you are looking for.
USE pubs
GO
CREATE TABLE appointments2
(
patient_id int IDENTITY(2000, 1) NOT NULL,
doctor_id int NOT NULL,
...
June 24, 2003 at 1:51 pm
The execution plans should be same too, Have you verify that? Is the sp_configure identical on both servers?
June 24, 2003 at 12:13 pm
Chris is right. You have to have both SQL Server at same level of SQL Servers and patches for master database restoration.
Edited by - Allen_Cui on 06/24/2003 11:49:34 AM
June 24, 2003 at 11:49 am
Viewing 15 posts - 1,576 through 1,590 (of 2,387 total)