Hi,

in book online it says you can define up to 64 backup devices for example:

backup database bigdb to disk='k:\bigdb1.bkp', disk='L:\bigdb2.bkp'

Hope that helps.

Best regards,

Holger

Hi,

you need to download this:

SQL2000-KB884525-SP4-x86-ENU.EXE 66.9 MB

Just another tip after installing SP4 try to get the latest Hotfix and apply it also.

Have fun.

Regards,

Holger

Hi,

I have recently transfered around 270 millions of rows from one Server to another using the following:

Linked the destination server to the source server and then transfered the data with...

Always use the same datatype for the parameter as the column or the function in the query. Otherwise SQL Server needs to do a conversion or chose the wrong...

Hi,

If you're using the wizard to create the maintenance plan select the database and then click next after you have clicked 5 times next you get to the page where...

The first cons I can think of is one database if it gets corrupt or something else happens to it, then your company will stand still.

Best of luck.

Holger

or restore your old system databases!

open Enterprise Manager right click on databases - all tasks - attach database.

In the new form click the button with (...) and then browse to your databases.

regards,

Hi Carl,

No problem. At least there's an easy workaround for it.

Best regards,

Holger

Hi Carl,

I think you've hit a nice known bug in SQL Server.

Have a look on this article:

http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B892803

Regards,

Holger

Hi Carl,

Do you have any error messages in the errorlog?

Regards,

Holger

Hi Sardar,

every traceflag can bring performance issues. But to analyse your deadlock issues you should have a look at the blockerscript. You can find it here:

http://support.microsoft.com/kb/298475/

Regards,

Holger

Hi,

Maybe there is still something left from the previous installation. Have a look on this link:

http://support.microsoft.com/kb/320873/EN-US/

this will help you to remove manualy SQL Server.

Regards,

Holger

If it doesn't help have a look on this link in the MS VKB:

http://support.microsoft.com/default.aspx?scid=kb;en-us;139444

regards,

Holger

Hi,

Have a look on this link to the MS VKB:

http://support.microsoft.com/default.aspx?scid=kb;en-us;224071

This article explains how to move user and system databases.

Regards

Holger