differential backups contain all the extents that have been touched by updates, therefore a single row update would lead to 64k worth of backup. Educated guess some process or processes...

you cannot alter the trace in flight, just stop and restart the trace and it will pickup the new settings.

if this is a server side trace there must be a trace script file somewhere. In there there will be a set @maxfilesize statement, alter that to the value you...

There is no simple way to do this without sysadmin I am afraid,, its a design flaw in SQL, but an intended one. There is a connect item about this,...

balasach82 (4/4/2013)

---

What could be the reason for the below messge?

SQL auth is enabled, Login, user, db access are all provided.

Login failed for user 'ZZZZ'. Reason: Could not find a login...

use the one for 2005 and above.

grant connect they would have anyway but there might be other rights granted to logins in that list.

you now have everything except default language -

select 'exec sp_defaultlanguage ',+"'" +name...

two things come to mind -

full text indexing

and if you have enterprise edition fuzzy grouping in SSIS advanced data flow transformations.

SET NOCOUNT ON

SELECT 'USE' + SPACE(1) + QUOTENAME('MASTER') AS '--Database Context'

-- server Role Members

SELECT 'EXEC sp_addsrvrolemember @rolename =' + SPACE(1)

+ QUOTENAME(usr1.name, '''') + ', @loginame ='...

database permissions for users are all held within the database, so once the login is tied up with the user via the sid, user database permissions will all be correct.

and if this is production I would turn autoshrink off. when you look at the report it will be obvious why from the constant shrinks and re-growths I expect you...

all shrink events appear in the default trace and you can see them listed under database - right click - reports - standard reports - disk usage.

Reindex jobs are the...

no problems, at least its a one off operation and the database can be used whilst you are doing the reorg.

....and to know where the last active vlf is, run command

dbcc loginfo(yourdbname)

the last row with a '2' in the status column is the last active vlf, the log will not...

ErikMN (4/1/2013)

---

There are a handful of tables in the database but one of them is about 80% of the data and another is about 15% so those two tables hold...