so, what happened in the end?

Lynn Pettis (5/20/2009)

---

I have to make a plug here. If you find yourself needing to go to compressed backups, look at HyperBac. It can be installed and configured...

cross post. answer here

http://www.sqlservercentral.com/Forums/Topic720807-149-1.aspx?Update=1

sigh. cross post. 🙁

http://www.sqlservercentral.com/Forums/Topic720958-391-1.aspx

I asked on other thread if its in mixed mode.

If you do have to waste time by shrinking, grow the data and log files afterwards to values that will accommodate normal database use, turn autoshrink off and leave it...

there is nothing to shrink, you have no free space because of the autoshrink.

Anyway all shrink will do is move extents about, it won;t overwrite data within pages and therefore...

check the authentication mode of the SQL instance, is it windows authentication or mixed mode ?(check properties - security)

It needs to be mixed mode, if it already is post the...

New_to_being_DBA (5/20/2009)

---

I had to delete 71 records with sensitive data. My boss is paranoid and wants to free up the space that the data was in. He wants to make...

I would agree with Jack. If one set of backups is interfering wit the other something needs to give, and it should be the third party backups, I don't think...

If you detach\move\attach you lose the ability to easily back out so detach\copy\attach is safer.

I usually go the backup\restore method but thats really just a personal preference and it...

TKE402 (5/19/2009)

---

Thanks for the reply.

I thought snap shots were only for SQL 2005 enterprize edition? I'm on standard.

My third party vendor says that transactional replication will definitely break the app....

Krishna Potlakayala (5/19/2009)

---

Gaby Abed (5/19/2009)

---

RPSql (5/16/2009)

---

-if percent fragmentation value is less then 5% then we will not run rebuild/reorg index against that index.

-if percent fragmentation value is between 5% to...

good, thanks for posting resolution.

I would still recommend switching to logshipping longer term

then is that backup normally taken with the copy only option, or is it normally restored on the standby server?, and one of these two things was not done.

I would...

why can't you?

has a full backup been taken?