Hi this is the script which gives details of permissions that an user or role is having to objects and also what users are connected with which roles under a...

Can you give me more details on this what exactly you are trying to do

copied logins from which server to which server.

Does user databases previously exist or restored?

Thanks Greg.

I have restored database by moving couple of database files where there is ample room to grow for data files.

Thanks Greg,

I have already started doing that as that is my last option.

I am trying to find is there any way we can get out of this situation.

--This is the script which generates script to restore tlogs after last full backup.

declare @dbname sysname

set @dbname =' '

select case When s1.type = 'L' then 'restore...

Why do you want to have a single user connected to system databases while doing your backups?

Dear Ashok,

See whether any users are connected to the database that you are restoring, if so ask them to change the database context or close their connections.

Query for you to...

Have a job for this, with all necessary permission that are needed on tempdb for required account and have this job scheduled to start when ever sql server starts.

No regular backups like full and differential doesn't affect logshipping.

Here is the script which gives you the details of latest backup files when it was taken with its location too.

select s1.database_name,s1.backup_start_date,s1.backup_finish_date,s2.physical_device_name

from msdb..backupset s1 inner join msdb..backupmediafamily s2

on s1.media_set_id =...

This data you have to collect for a prolonged duration across all drives also collect data for other counters for Object PhysicalDisk.

Frequency of collection depends upon how frequently sql server...

Find out the disk response time across drives for these counters

PHysical disk avg disk sec/ read, avg disk sec/ write and avg disk sec/ transfer, if the value continuoulsy...

This happens if primary and secondary servers drive configuration is not of same.

When Restoration of transaction log backup will fail after data file is added , find out the transaction...

Moving of database files will work for database that are marked for replication will work with thsi method, that is take the database offline, move the database file, point the...

If the database has more than 16 files then sp_attach_db will not work,

this will work with attach option by using create database command.

If database is having more than 16...