then we are back to the old appending backups rather than overwriting?

richrock (7/21/2008)

---

I have a similar problem: .mdf file is 2.3GB and the .bak file is 3.0GB. The log file was truncated before the backup was created and I don't use...

Johannsky (7/20/2008)

---

Thanks for your post.

I am actively monitoring the logs if there are errors but all jobs are executed successfully.

3 days has passed, the .trn grows to 23Gb but non...

rinu philip (7/20/2008)

---

Processed 1768 pages for database 'DB', file 'System_Data' on file 1.

Processed 85000 pages for database 'DB', file 'DB_Data' on file 1.

Processed 15272 pages for database 'DB', file 'DB_Index'...

you may be running out of memory because of whatever else is running on the server. Look at lastwaittype in sysprocesses, if you see a lot or resource_semaphore waittypes this...

this is in the 2005 forum but you stated you are using sql 2000, in that cases you cannot use schemas

...or in the job history or in the logshipping tables in msdb.

is the target database now in standby/read only mode?

IThere is no database setting that will prevent loss of permissions if a stored proc is dropped and re-created. maybe its some setting in their app that changes the drop\re-create...

it would be, but unless you really need the space back, don't bother, you will fragment you log file at the OS level.

exactly, i don't think a security group should get involved at this level of detail, just satisfy themselves protection of data has been taken into account.

a security group might define what various parts of the business should be able to do, bur the DBA should work out how these will be enforced within SQL and...

aliciakw (7/16/2008)

---

I have had this situation happen to me. The transaction logs have been deleted from the Primary Server before being applied to the Secondary Server and now the...

also, read this article:

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/logship1.mspx

unless you are planning to regularily fail over then it is not necessary to check the box.

to make secondary the live database:

bringing secondary database online

either

restore database dbname with recovery

or...

see my earlier post on how to bring it online. If the...