Viewing 15 posts - 1 through 15 (of 16 total)
If you restore with the RECOVERY option then you can not restore additional logs. But if you specify NORECOVERY or STANDBY you will be able to restore more logs. When...
December 26, 2002 at 1:40 pm
As mentioned run "DBCC CHECKDB" on the database first of all and see what it recommends. Hopefully it says you should run the command again with the parameter "REPAIR_FAST" or...
December 25, 2002 at 5:25 pm
If you are on the same server use a server reference as mentioned. If you in the future need to do the same thing against another server you need to...
July 17, 2002 at 2:36 pm
This is so unbelievably on target. I had this exact same problem and MS had no fix for it. THX!!!
June 6, 2002 at 9:08 am
Yup, no real way to prevent domain admins to do something malicious unless you disallow domain accounts completely which might not be a good idea. Hopefully the domain admins can...
April 1, 2002 at 6:45 am
We've had the same problem and the reason for the "error" was that the SQL Server 7 database that was moved had a different sortorder/collation than the SQL Server 2000...
March 31, 2002 at 6:34 am
quote:
Argyle,While your method will prevent casual poking around in the database, any Domain Admin could easily get into the MSSQL\ directories, even...
March 31, 2002 at 6:17 am
Can add that searching trough the mails I have on those lists I get over 200 hits on "parallelism" (not saying all are related to problems but many are). The...
March 25, 2002 at 3:17 am
It really depends on what environment you work in. If you only have a few databases on a few server and you have control over all the queries then fine,...
March 25, 2002 at 3:00 am
Did you change the SQL Server service account maybe?
Check this KB:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q277549
March 23, 2002 at 5:58 am
I prefer to be on the safe side since there have been so many issues with it on SQL7 and there still are on SQL 2000. It's not always it's...
March 23, 2002 at 5:40 am
First select the option "Create a new instance of SQL Server, or install Client Tools".
On the next screen enter name and company.
On next screen agree on license.
Then on...
March 23, 2002 at 4:27 am
There are some issues with parallellism in both SQL Server 7 and 2000 though that could cause your queries to run slower and even return incorrect results when this options...
March 23, 2002 at 4:21 am
It happends sometimes that a database get stuck in "loading" state when you create it or restore it. Just remove it with sp_dbremove or restore over it as you did.
/Argyle
...
March 23, 2002 at 4:13 am
Search the index in Books Online (BOL) for "collations" and you will find a lot of info.
Collations define "rules" for what type of characters you can store in your database...
March 23, 2002 at 4:01 am
Viewing 15 posts - 1 through 15 (of 16 total)