I want to move a sql server currently used by some application servers to a
new host.
the old host is
windows 2003 std (4gb ram) (2cpu) SQL 2000 std

I have a problem while I restore database from Microsoft SQL Server
2005 v. 9.00.1399.00 to Microsoft SQL Server v. 9.00.3042.00 on
another server in the same domain.
During restore database name OrganizationName_MSCRM I have got an

In SQL 2005
BACKUP LOG [MYDB] WITH TRUNCATE_ONLY  can truncate log file.
How to truncate log file in SQL 2008?  
Thanks!

SQL 2005 standard, Windows 2003, 60GB db, 8GB ram, 4 x QUAD.
Im trying to understand what is causing massive performance issue with my
DB.
CPU = free resources are 99%

I am looking to purchase 2 x CPU licences of sql server 2008 standard.
In my country, the software costs substantially more than what it costs to
buy in the USA.
If I fly to the USA and personally purchase the software, will the licence

There are tons of articles describing what needs to be done in order
to fix a corrupted Master.ldf/mdf
but I cannot find anything that explains why this actually happens or
how to minimize the chances of it.

Based on the following stats (every 3 minutes) what would the contributing
factors for extreme slowness on the server?
Buffer Distribution            Buffers    
---------------------- -----------

Get the following message when trying to attach db on SQL 2000
Could not find row in sysindexes for database ID 8, object ID 1, index ID 1.
Run DBCC CHECKTABLE on sysindexes.
Have no backup of the db so trying to attach as it is the only option

This is design question.  Business requirements specify that we have a global
database (global to all clients) and a unique client container for each
client holding all specific tables for that client. Having the ability to
backup/restore for a single client is needed. This ...

Hello
I whant to know if I change windows username and password whan SQL server is
running will SQL server update that information and how to update if not
I want to promt me for the new user name and passwort

We are running SQL 2000 and for some reason TempDB LDF is getting too big.
TEMPDB MDF is only about 35MB while LDF has grown to 11+GB in three days. I
have confirmed that it is growing by a few MB every few seconds. I read a
prior post with similar issue and ran the commands ...

Is there a SYS view available that show the included columns? Sp-helpindex
does not.
Thanks in advance.

I have to Two Server Say X and Y.
Y has Data right from day1 to current.
while X has only current month records.
the frequency of merging will be after every 20 days.

I've long used Access as a method of combining data from two sources.
Half of the data is in our SQL Server, the other half is in a PSQL
server that runs our accounting system. Using Access to combine these
sources is a problem; it means everything has to run client-side for

i'm trying to restore a log via trn files.
Now I get the message:
The log in this backup set begins at LSN xxx, which is too late to apply to
the database. An earlier log backup that includes LSN yyy can be restored.