why dont you make a maintainance plan in which first step take full backup and schedule it and then add a clean file task to the second step and delete...

Not yet so far, i was just wondering why they all are different,

Cheers

you mean the Upgrade advisor, thats when you migrate from 2000 to 2005, is sql service pack 3 is being used now a days. what kind of service pack you...

allrite, thanks for your quick response, if you found any please post it here, unfortunately we dont have MS support for our company,

Thanks

Thanks and one more thing, so this are the sql builds after service pack 2, but where can i download it and apply to older versions,

Thanks

how can i get that

we use T-Replication to keep sync one of our report server for reports purpose from the production, if your data for QA guys is ok to see then you...

And this is what its showing me in the distributor server agent jobs. this is a SQL 2005-2005 replication and distributor a separate box and has sql 2005.

Date10/26/2008 4:04:41 AM

LogJob...

thanks guys, i will talk this in our meeting and renaming is not a problem, but i guess if they want a new id to be replaced with sa then...

will it work for system databases too

Thanks guys, i have seen my sql server properties and checked the processors tab in it. all the 4 processors are selected and i can see like both the other...

Hi Guys,

I have now got all the permissions access to the reports, and now i can see the EDIT tab and open and save the .rdl file, but how do...

i have T-replication, I usually stops the log reader agent from the publisher and synchronization status from subscriber and start them whenever needed.

why dont you just take a full backup and restore it in 2005.

well guys i am the only person in my company and no one else knows sql, and also i am new to the environment here, they say i have full...