syntax seems to be wrong...

'GO' are missing......

Good.

Thanks Guys.

However, neither powershell nor xp_cmdshell, do work in SQL Server 2000 !

Hi Guys,

I have wholly modified the script as below. Please do execute this and suggest if this is looking fine now.

select a.name, case b.type

when 'D' then 'Full Database Backup'

when 'I'...

Hello,

I know about SSIS, however, if you could share such scripts in steps, I can modify and make use of it.

But yes, creating so many linked server might not be...

select distinct @@servername 'servername', convert(varchar,a.backup_start_date,121) 'Date_time', a.database_name 'DB Name',

convert(decimal(7,2),round(sum(b.file_size/1024/1024),3)) as 'Database Size in(MB)',

s.physical_device_name

into #t1

frommsdb..backupset a

inner join msdb..backupfile b on a.backup_set_id = b.backup_set_id

left join backupmediafamily s

on a.media_set_id=s.media_set_id

where...

Ofcourse regular log backups are scheduled.

Question to this context is, if there are massive transactions are running at publisher end and the LDF file is growing what is the best...

What is the query/table to check the execution plan of the queries until we restart the SQL Server?

Please suggest.

why not all the system databases are created with FULL Recovery model?

What is the architecture behind?

Hi D.Post,

Can you please share the script with me which automate the entire process?

Cheers

Lynn,

Can you share the script to use?

I can't run it twice!!! 🙁

Since the timestamp would be different while running twice! So typically that would be two seperate backup copies.

Can you provide any other suggestion instead please?

Somehow...

MIRROR TO OPtion is good, but unfortunately this too won't help...due to version issues.

Msg 3218, Level 16, State 1, Line 29

Backup mirroring is not available in this edition of...

Durai ,

We need the same backup copies of all the databases to be available in local disk and also in the network drive!

The script which you sent will either place...

which takes up more resources like, CPU/memory/less use count. I assumed in this way