I don't apply CU's unless I hit the bug they address but starting with a fresh dev install is the one scenario where you can safely include the latest CU...

Any database restore from another server across the network will result in an entry in the backupset table.

check msdb..restorehistory as well

are you using log shipping?

I have installed without issues.

As above but make sure you have administrator rights on the box and to run the patch, right click and select 'run as administrator'

paruchuri4 (9/26/2012)

---

I am not considering about space but some databases are generating 0Kb size when they are taking backup for that purpose i need to know the size, if the...

there's no shame in using maintenance plans for backups if they suit your needs.

A weakness with them is they do not failover at all well in HA\DR solutions that involve...

The error 'Conversion failed when converting date and/or time from character string.". ' is usually associated with language settings. Is the default language for the server\login\connection different between prod and...

under sql agent - properties - history there is also a setting for limit size of job history log. This defaults to 1000 so if you have a lot of...

I would think the important part of the error message is this - 'Login failed for user 'apr12_sathiyan'.".

'

Check the SQL errorlog at the time the package ran for more information...

it depends.

You can log ship to the same instance or to multiple instances, so thats any where between one and many servers. (I'm equating servers to instances for this example).

You...

all mine are at SP4 and I haven't had an issue. Apply MS11-049 security patch as well.

another option is the bcp utility with the 'query' parameter

I don't think you can guarantee there won't be a harmful effect -

http://msdn.microsoft.com/en-us/library/ms175527(SQL.105).aspx

http://www.mssqltips.com/sqlservertip/1980/sql-server-tempdb-one-or-multiple-data-files/

and paul randal says only add multiple files *IF* you have latch contention.

not sure this was a microsoft...

If you are sure you want to do that............

select 'alter authorization on database::['+name+'] to [sa]'

from master.sys.databases where database_id > 4 -- DO NOT change ownership of system databases

I'll moonlight and undercut these guys by 10% 🙂

edit: cash only