cwitucki, why not perform REPAIR_FAST or REPAIR_REBUILD before use REPAIR_ALLOW_DATA_LOSS?

These repairs can be done without risk of data loss.

Just curious...

Franco

If you have SQL Server 7 and have different sort order,local unicode,unicode collation or different character set, you will need to rebuild master database with rebuildm.exe utility.

From BOL:

Before you run...

From Neil Pike:

You have three choices:

1.Use the DTS transfer wizard. Set msdb as the source and destination databases and "select * from sysdtspackages" on the source.

2.Save each DTS package as...

"I wanna now transfer DTS packages from SQL7 to SQL 2K but how ????"

Go to your DTS package and choose "save as...", you can choose the location where to...

If you don't care about point in time recovery you can turn the option "truncate log on checkpoint to true".

Please remember that if you have to restore your database you...

Please refer to:

http://support.microsoft.com/search/preview.aspx?scid=kb;en-us;Q303287

HTH

Franco

You may need to check the exact dimension of the *.MDF and *.LDF files.

Sometimes the size of a backup file does not tell us how much space you will need...

Please refer to this link:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q246133

HTH

Franco

Franco

In Query Analyzer run this:

sp_configure 'show advanced options', 1

GO

RECONFIGURE with override

GO

sp_configure

You will find all the informations you need.

Remember to set 'show advanced options' to 0 again after you have done.

HTH

Regards

Franco

Franco

For SQL Server 7 on Cluster I have found this link:

http://www.sql-server-performance.com/clustering.asp

and here is the explanation on how to restore master db on cluster:

Tip: Don't restore the master database...