Can you please see the old sql server errorlog when the model database last worked. Is the server is now up and running ?. or is there any outage?....

why dont you try this:?

SET NOCOUNT ON

DECLARE @Handle varbinary(64);

DECLARE @SPID INT;

declare @SpidStatus varchar(100),@LoginName varchar(100), @HostName char(250),@DBname sysname,@CTEXT VARCHAR(8000)

DECLARE [Spids_Cursor] CURSOR FOR

select spid, db_name(dbid) as dbname,loginame,hostname from master..sysprocesses...

In that case, i believe something has gone wrong. Can you please check the eventvwr, errorlogs to check if anything fishy happened.

Hi ,

Can you please set the default locations for the databases on the server properties and restart the server and check if all the databases are coming up.

Hi,

Its a great script. We use this stored proc to loop through all the databases in another stored procedure.

I have used like this

SP_MSFOREACHDB 'EXECUTE DBO.USP_DBBackup ''full'',''?'',''E:\sqlbackups'',''1'',1'

My suggestion are.

1. The...

Hi,

You can see the log fil by using the function.

Use database_name

go

select * from fn_dblog(null,null)

I have provided the code as is. Please take special care and attention before running the command....

Hi,

These backup files extension names like .bak, .bk, .trn are all for our reference. Infact you can take the database backups or the log backups without the file extention...

Hi,

These backup files extension names like .bak, .bk, .trn are all for our reference. Infact you can take the database backups or the log backups with the file extention...

I mean not to truncate the log,. you can shrink the log file after finding the low usage of the log file.

Hi

Immedietly schedule a transactional log backup job to take the transactional log backups on the database. And before that please do one full database backup and start the transactiona log...

Hi,

It looks like, its a heavily used database and a lot of transactions to be saved. You may need to add the additional log file pointing to free disk. Taking...

Hi,

The error description shows that the problem is not with the transactional log backup, the error says

BACKUP DATABASE and not BACKUP LOG.

Please check wether transactioanl log backup is coinsding...

Hi,

Can you please let me know how frequently transactional log backups are taken. Try to schedule it to every 30 minutes or hourly basis if possible. There is no meaning...

you can surf here

http://www.flazx.com/category62.php

Hi Friend,

By default Primary key creation clustered index and you are placing the clustered index on the another file group, as the clustered index moves the data and index keys...