sorry truncate_only present in sql server 2005 .

Just verified 😀

anthony.green (11/8/2012)

---

Probably as I stated on my post above, the active portion of the log was at the end and it needed the second backup to move the active portion...

what is the output of the

dbcc loginfo( YourDBName)

also

select log_reuse_wait_desc from sys.databases where name = 'YourDbName'

its working fine for me in SQL serevr 2008 R2

or else another option is

ALTER AUTHORIZATION ON DATABASE::YourDatabaseName TO sa

GO

Hi Gail,

But MS specify in Books online that

To make AWE available to an instance of SQL Server, use sp_configure to set...

Hi thats just a informational message ..

I think link below will...

please check if there any db_owner for your database used in replication.

if there is no change it to SA or any other active login

use Yourdatabase

go

sp_changedbowner 'sa'

I got it wrong ...

you should mention sql server Version in question .

Sysdatetime () not present in sql 2000 and 2005

Thanks a lot Anthony and Lowell 🙂 ... Thats works just fine for me .

Bhuvnesh (11/7/2012)

---

YEs. any change to the cluster keys forces all the non-clustered indexes to...

will it work ?

diff backup should be applied to its earliest full...

Bhuvnesh (11/7/2012)

---

@sanket why tuesday full back which is not there (for arcserve )

see

I also have a daily direct backup of database via arcserve SQL agent to tape at 11pm:

Monday to...

chewychewy (11/7/2012)

---

Hi Guys,

For example only.

I have a daily full db backup via SQL maintenance plan to file system at 10pm.

I also have a daily direct backup of database via arcserve...

DesmoShane (11/6/2012)

---

I would like to move a clustered index from one filegroup to another on a production database without causing any disruption for users and was wondering if this is...

Duplicate post

http://www.sqlservercentral.com/Forums/Topic1381740-1292-1.aspx