hi,

i'm not quite clear on the location of the temp table. Is it a sql server temp table, created by the application, or is it a access temp table, created...

And do every night something like:

exec dbspCheckErrorLog 500000

___________________________________________

CREATE procedure dbspCheckErrorLog

@limit float = 1000000

as

declare @size float

create table #logs

( Lognum int

, Logdate varchar(22)

, Size float

)

insert into #logs exec master..xp_enumerrorlogs

select @size = size...

And it gets a lot more complicated if you've got tables with dublicate primary keys after the collation change, say you have a pk on a varchar field that is...

Hi,

you might simply change the server collation of the development server. That will change the collation of the system databases, but not the collation of your user databases. The collation...

Log in as service user, edit the mail profile, make sure that you are receiving mails into the mailbox, and not into an local folder.

HTH

karl

In Step 1 you should do an

BACKUP LOG Database_Name WITH TRUNCATE

instead of an

BACKUP LOG Database_Name WITH TRUNCATE_ONLY,

because with truncate_only you are cutting the chain of log backups, and...

Do you restore the full backup into the standby server? if yes, do you restore "with norecovery" or "with standby=xxx.ldf"?

Do you restore all transaction log backups also "with norecovery" or...

Hi,

restoring should be no problem, if the paths to master, model, msdb and tempdb on the dr-server are the same as on the cluster.

MS SQL Server clustering is mainly an...

Hi,

try:

sp_helpfile

CHECKPOINT

--declare @cmd varchar(999) select @cmd= 'backup log '+DB_NAME()+' with truncate_only' exec (@cmd)

dbcc shrinkfile (DB_Log, 3072)

if that does not work uncomment the backup-line and try again.

if you need all transactions do...

It would depend on the initial configuration. At some point i read a recommendation for sql clustering which stated you should put the system databases on a local disk of...

back to the log files:

you should set autogrowth to yes, amount to 30 or 50 MB, limit to nearly the amount of available disk space.

Reasons:

If the transaction log is full...

If you restart the restore later, does it work or do you get the same error?

Hi,

looks like the db tries to use a wrong log file. Do the file paths to the log file actually match on both servers? (looking at master.sysfiles, master.sysaltfiles and medanes.sysfiles...

Hi,

you can define a view like:

CREATE VIEW dbo._v_Item

AS

SELECT *

FROM OPENROWSET('MSDASQL',

'DRIVER={SQL Server};SERVER=test;UID=xx;PWD=yyyy;',

'select No_, Description + '', '' + [Description 2] COLLATE SQL_Latin1_General_Cp1_CI_AS as Description, [Item...

hi,

is the database marked as (failed)?

if yes, you can set the database to emergency mode and use dbcc rebuild_log to rebuild a proper logfile... (for the correct syntax search this...