Board index MS SQL Server

HELP ME MY LIFE IS AT RISK

HELP ME MY LIFE IS AT RISK

Post by Nuno Sec » Thu, 08 Jul 1999 04:00:00



I HAD A PROBLEM WITH A HARD DISK ON A SERVER (BAD BLOCK).
THE FIRST THING I DID WAS BACKUP A DATABASE. THEN I CHANGED THE
HARD DISK, INSTALLED SQLSERVER AND WHEN I GO TO RESTORE
IT GIVES A SORT ORDER ID ERROR, SAYING THAT THE ORIGNINAL
SERVER HAD A SORT ORDER ID OF 52 ON THAT THIS ONE HAS ONE OF
82 AND IT DOESN'T LET ME RESTORE THE DATABASE.
PLEASE HELP, I AM VERY DESPERATE.
I AM USING SQLSERVER 6.5
 
 
 
Top

HELP ME MY LIFE IS AT RISK

Post by Gary » Thu, 08 Jul 1999 04:00:00


When you installed SQL Server on the new hard drive you did not select the
correct  sort order from the installation options dialog box.
Sort order ID 52 is Dictionary Order, Case-Insensitive.
You need to reinstall SQL server and select the correct option.

Gary Fairchild


>I HAD A PROBLEM WITH A HARD DISK ON A SERVER (BAD BLOCK).
>THE FIRST THING I DID WAS BACKUP A DATABASE. THEN I CHANGED THE
>HARD DISK, INSTALLED SQLSERVER AND WHEN I GO TO RESTORE
>IT GIVES A SORT ORDER ID ERROR, SAYING THAT THE ORIGNINAL
>SERVER HAD A SORT ORDER ID OF 52 ON THAT THIS ONE HAS ONE OF
>82 AND IT DOESN'T LET ME RESTORE THE DATABASE.
>PLEASE HELP, I AM VERY DESPERATE.
>I AM USING SQLSERVER 6.5


 
 
 
Top

HELP ME MY LIFE IS AT RISK

Post by Tibor Karasz » Fri, 09 Jul 1999 04:00:00


...and codepage 1252 (ANSI, ISO, 8859-1, whatever you choose).

--
Tibor Karaszi
MCDBA, MCSE, MCSD, MCT, SQL Server MVP
Cornerstone Sweden AB
Please reply to the newsgroup only, not by email.


> When you installed SQL Server on the new hard drive you did not select the
> correct  sort order from the installation options dialog box.
> Sort order ID 52 is Dictionary Order, Case-Insensitive.
> You need to reinstall SQL server and select the correct option.

> Gary Fairchild

> >I HAD A PROBLEM WITH A HARD DISK ON A SERVER (BAD BLOCK).
> >THE FIRST THING I DID WAS BACKUP A DATABASE. THEN I CHANGED THE
> >HARD DISK, INSTALLED SQLSERVER AND WHEN I GO TO RESTORE
> >IT GIVES A SORT ORDER ID ERROR, SAYING THAT THE ORIGNINAL
> >SERVER HAD A SORT ORDER ID OF 52 ON THAT THIS ONE HAS ONE OF
> >82 AND IT DOESN'T LET ME RESTORE THE DATABASE.
> >PLEASE HELP, I AM VERY DESPERATE.
> >I AM USING SQLSERVER 6.5

 
 
 
Top

1. Need help changing passwords (Old DBA may be a security risk)

Our DBA just recently left under negative circumstances, and I have
been tasked with securing our production servers.

We have a SQL Server 7 instance running on NT4.

I know that we are:

--Replicating data to another machine.

--Make a daily snapshot of the database and backing up the log files

--Have  jobs running that monitor failures to properly call External
Stored Procedures, and attampt to recall them.

There are several users with DBA priviledges on the machine...SA, and
others.

The question is, if I needed to change the password for these users (I
have permission levels), will the jobs and other processess
automatically accept the new password?

Are there any other caveats, I should be aware of?

I appreciate any feedback :)

Michael Bates

2. Why not NoMatch?

3. HELP on The Life of a ##Table

4. ASP.NET, ODBC and FileMaker Pro 5.5

5. Need Real Life Figures and Help...

6. How to fax from Oracle database?

7. Help needed with life saving Asthma application

8. FAQ? and Q&A?

9. HELP SAVING A LIFE

10. I am getting this message when i am tring to export or import anything using

11. error ORA-01855: AM/A.M. or PM/P.M. required

12. Busy Day = Slowdown from 12 AM - 5 AM

13. Use of @am, Am I dumb?


All times are UTC
Board index