ReadOnly Databases cannot be modified. Adding access to the database means modifying the database, which is not possible.

there are 2 ways(that i can think of), grant the user access in...

BACKUP LOG GLReporting WITH TRUNCATE_ONLY

This will delete all your transaction log entries. if you are maintaining Transaction log backups, the chain will no longer be useful, in case of a...

The backup size will be 300GB + Required Transaction log + DBInformation(approx). It will not include the 200GB free space in the database files.

However, when you restore the backup, the...

This approach seems correct. the NumOfOccurences always showing 1 means there are no duplicate names in your table. try and insert 2 duplicate values(in dev environment) and then re-run the...

hi,

after the transaction, issue a checkpoint and wait for a minute or 2 and then start the second batch.

Regards

This should work

SELECT CAST(@LineDate AS DATETIME), convert(datetime, convert(varchar,@date,101),101 )

(tweak the 101 to the kind of format you want).

dso808 (8/12/2010)

---

Hi and thanks so much for your help. Your suggestion sounds like the most feasible solution for our situation. We've also thought of perhaps setting up the...

Hi,

you can have a centralized server for Database Administration, where you can create SSIS package to monitor the job status for every server.

You can also create a centralized backup strategy,...

dso808 (8/11/2010)

---

HI and thanks so much for your reply. Yes, this is a very rough way to go about this and it's been a very unpleasant experience. I guess...

From...

eng_mgomaa (8/11/2010)

---

Copy-only backups are new to SQL Server 2005. They allow a backup of any type to be

taken without affecting any other backups. Normally, a database backup is recorded in...

hi Jason,

it will be in the backupset table.

however, the is_copy_only field will be 1, which confirms it is a copy_only backup.