Hi steve,

I have not implemented Mirroring or tested, but after going through various articles understood that only user created databases can be mirrored.

In this case if principal goes does, standby...

Command to restore database through sqllitespeed.

exec xp_restore_database @database = ,

@filename = 'BkpFile with location',

@with ='move "LogicalFileName" to "OSFileLocation"',

@with = 'move"LogicalFileName" to "OSFileLocaton"',

,

.................................. ,

@with ='recovery'

You can get this information from msdb.dbo.backupmediafamily and the column name is physical_device_name

Max characters allowed for specifying email addresses is only 100, beyond that what ever that is specified will get truncated.

The best option is to have ad groups created...

To me, there shouldn't be any problems if you move databases of same version from one edition to the other edition, as these are user databases.

Nothing can be done, you have to wait till entire database or log restoration is completed.

You don't have to reconfigure entire logshipping for this.

You can change the settings in 2 different ways.

1st Method.

1st step Execute this command on your primary server for...

What exactly is the requirement?

You can view list of objects through third party tools like SQLLiteSpeed ,Hyperbac

We also have same issue, the work around what we do is , this is really working for us.

DECLARE @age INT,@sqltext nvarchar( )

SET...

What configuration you want to change?

You can restore master database using sql litespeed. reason being once sql server is started in single user mode, when we try to restore master databse using sql litespeed,...

Are you planning to migrated all databases on to new server

If so you can give a shot by following the given below steps( this is what I tried...

Your disk is being subjected to high stress based on the peformance counters numbers.

Also are the values provided for various counters are for _Total instance, if so start collecting data...

Hi Balbir,

Filegroups cann't be moved they are logical, only database files which are phyiscal can be moved.