For MSDB, the daily full backup will suffice the pupose of securing the necessary data, why tlog is necessary? am i clear now..

Gail correct me if i am wrong wont the daily full backup...

Adam,

do you have any document on this i got to know how to change the port but need to understand the connectivity part before even proceeding the testing.

because i need...

if you want to rename a named instance, read the below link.

http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/d5d297b0-2995-46ba-9d3b-d1ec8825f479/

i havent tried it but got through google.

thanks RSScriptor we have and report movment is not an issue.

the only thing concerned is access configuration.

thanks for all the information , i'll check for the AD access with the...

our setup is

A New SSRS server will be created in new domain.

Datasources use sql user connection.

thanks antony

All the users and servers and moving to new domain and old will be Decommissioned once the new domain started.

The access will keep on getting change that why...

Experts you views.

Sourav-657741 (7/2/2012)

---

Durai ,

We need the same backup copies of all the databases to be available in local disk and also in the network drive!

The script which you sent will either...

Hope this helps.

option 1 : create 2 step of backup for local and network, create maitanence cleanup task for local and network.

option 2: create script for each db on one...

is there any thrid party tool which will help in this regard. free or nominal charges..

Try that in SP_who2.

how big is the table ( no of columns and records)?.

index details?

update and select are happening frequently?.

Poor code so DB.

we got the error once when a dormant session blocks numeruous connections at that time.

before i diagonise i was in urgency to kill it.

once i killed it it took around...