San, you are correct, the alter database..modify file is the best option for moving database files as it is simple, quick and maintains the database owner and dbid.

please see my...

San-847017 (9/25/2009)

---

True. But that will leave you with 2 databases unnecessarily. The queston was to to...

other way round, if you want th bulk insert minimally logged...

let us know how it goes.

george

I believe because the SQLagent kicks off the job BUT the backup command itself is run by the database engine therefore the SQL service account needs access.

Only a bounce of...

yes, they can be changed independently, BUT, when a database backup command is run it is run by the database engine NOT SQLAgent, I think this maybe why you get...

this phrase in your original post:

The SQL Server service was previously a local system account but has now been changed to the same domain admin account as the SQL agent...

log files will only get smaller if a shrinkdatabase or shrinkfile command is issued.

Any of these indexes clustered? I see the word 'heap' in your result set which suggests not.

just setting recovery mode to bulk logged is not enough to guarantee minimal logging, a number of conditions have to be met:

bcp and bulk insert:

table not replicated

tablock hint used

no clustered...

is this SQL2000 or 2005.

In 2005 it is standard behaviour to clear down the whole proc cache for a restore, which is kinda annoying. Can you restore your logs less...

if the db is in full or bulk logged mode are you backing up the transaction log?

a reindex might cause your log to match the size of the data

Danb7183 (9/23/2009)

---

Thanks Silverfox.

I've attempted your suggestion but it still returning the same:

Msg 3201, Level 16, State 1, Procedure spTestingBackup, Line 11

Cannot open backup device '\\ServerName\DB_Backups\DBName\DBNameFull_20090923_1233.BAK'. Operating system error 53(error not...

try making the destination a share and backing up to the share name.

Its not unusual for a reindex to produce log = to the size of the database. If you have a lot of fragmentation a lot of data pages are going...