Have you tried executing the backup statement urself under mgmt. studio or query analyzer?

MJ

This option is available only 2005 onwards.

MJ

All data file creation/extension options will use instant initialization for data files created on NTFS volumes when SQL Server 2005 is running on Windows XP or Windows 2003 Server. Its...

Its called Database File Initialization

http://msdn.microsoft.com/en-us/library/ms175935.aspx

MJ

Have you included Showplan XML EventClass in profiler trace? Include it and then click on that row and right click on it and chose Extract Event Data and save plan...

Nope it won't work, you need to rename the existing one.

MJ

Try this:

--http://www.sqlservercentral.com/scripts/Administration/63841/

USE MASTER

GO

BEGIN

IF LEFT(CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR(1)),1) = '9'

IF EXISTS (

SELECT TOP 1 *

FROM Tempdb.sys.objects (nolock)

WHERE name LIKE '#TUser%')

DROP TABLE #TUser

ELSE IF LEFT(CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR(1)),1) =...

Try this:

1. Restart WMI service.

If still not resolved then tell me where exactly are you getting this message on client machine or only on server?

MJ

Try this:

select c.name,c.length,c.xusertype,lc.name,lc.length,lc.xusertype from sysobjects o inner join syscolumns c

on o.id=c.id

,[DestServerName].northwind.dbo.sysobjects lo join [DestServerName].northwind.dbo.syscolumns lc

on lo.id=lc.id

where c.name =lc.name

and o.name='orders'

and lo.name='orders'

I wrote this test code for comparing northwind database orders table...

Did you try this:

In order to change the dynamic port of the server to the static port in the clustered named instance of the sql server 2005 we need to...

Nope file won't get renamed by this. Downtime is still there as you are going to rename the existing database. Better detach the existing one and rename its files and...

It worked like a charm. Thanks a lot guys.

Manu

Actually you can't have DAC from object explorer.

DAC is not supported for the object explorer, only for the query window.

Manu

Try this:

Go to File menu-->New-->Database Engine Query.

Select Database engine and then enter ADMIN:Servername.

This time it shld work.

HTH!

Manu

Make sure sql browser service is started and remote connections are allowed in case of remote DAC connection.

I am able to get DAC connection by following the info in the...