yes but you can only document database objet note SSIS et sql job et not able link database owner ship i would like document

server

owner ship for DB

application or web link...

oups forget reaply SP3 after at the end

if you SSRS is not connect to sharepoint you may fallow this step

1 install SQL2 and apply same SP not install SSRS

2 restore user database

3 recreate security or restore...

into my entreprise i'm use red-gate SQL backup and i'm backup 1 terrabyte into 30 minute other solution is look for snap you san drive and mount snap drive on...

you database is store into san or standard disk ?

it is possible is wrong insert is generate oldeste data if you leave data next run data delete or leave for ever whitout intervention

personaly i prefair seperate leave os alone in c into my organisation i'm instal alaway like that

c:\ for Os and SQL engins include master et model MSDB

D: SQL data ...

i belive getdate -30 return not the same values depend some configuration for me is retuen this

for sql 2000 2005 and 2008

SELECT getdate() - 30,GETDATE()

...

http://www.sqlskills.com/BLOGS/PAUL/post/Search-Engine-QA-12-Should-you-create-multiple-files-for-a-user-DB-on-a-multi-core-box.aspx

need to cosider this for my futur system

the tap direcly table or views defrag or reindex is done after migration tempdb is same size in each server 2005-2008 same memory of 2000

if I should have 8 files instead of 4 but not sure if that would be benefical form my personal experience the only benifis il reduce contention when you have...

TempDB is use for all of this action

Query

Triggers

Snapshot isolation and read committed snapshot (RCSI)

MARS

Online index creation

Temporary tables, table variables, and table-valued functions

DBCC CHECK

LOB parameters

Cursors

Service Broker and event notification

XML...

whatch this

http://www.microsoft.com/downloads/details.aspx?FamilyID=82833f27-081d-4b72-83ef-2836360a904d&DisplayLang=en

and

http://vettekerry.wordpress.com/2009/05/04/unable-to-load-client-print-control-in-reporting-services-2005/

temdb data files move only after SQL service restart

http://support.microsoft.com/kb/187824/en-us

1 need install outlook on SQL server

2- SQL service need run with domain credential

3- ensure mailbox exist for SQL credential

4- log into server whith SQL credential

5- configure...