Hi,

The forum itself is your answer. Loads of questions/doubts each with responses from experts and experienced people. Go through them. These are all the issues that you may or may...

Thank you for your reply Maninder.

My main doubt is when MIRROR goes down in Synchronised mode mirroring, as the transactions at principal side will be waiting for the acknowledgement from...

Hi,

select name,physical_name from sys.master_files

Hi,

It does not throw any error at the schedule. It creates the job with the same schedule that runs at 12.15 as the original job. However, if the script has...

Hi,

Almost I experienced the same when I started my career as DBA 3 1/2 years ago. Running periodic checks (daily, monthly etc.,), running the release scripts, simple access issues etc.,...

Hi,

After you rename the primary DB, as the logshipping is configured on the <old database>, the transaciton log backup fails with the error:

Error: Could not locate entry in sysdatabases for...

Hi,

Configure an output file and see if anything gets logged when the job runs the Backup ( like 'Job started at ...').

Create a dummy step before the backup step with...

Hi,

It is very much similar to restoring to SQL 2005.

Restore the backup to SQL 2008 instance; Change the compatibility level; Change the procedures and other objects accordingly,Setting up logins...

Hi,

It can be done either way...

Restore DB from backup on the secondary with norecovery or standby option. Configure logshipping choosing the option that the DB already exists on secondary server

...

Basically, logshipping copies physical log files ( the back up files of transactional logs) over to secondary server and then the db is restored either in stand by more or...

Hi,

May be you can restore the MSDB from last backup with a different name on to any Test instance and run CHECKDB to make sure it does not have any...

Hi,

Try sp_helplogins 'loginname'

Hi,

While registering the server in SSMS, if you use the login(DevUser) that you want, it always opens through that login until you unregister it.

Hi,

I think you can query 'backupmediafamily' table in MSDB for backup locations.

Hi,

No. The backup job does not block any DML...