Thanks Shafat

I had already cleared it up. I was just inviting for more thoughts. Great link though. keep it up.:-)

I saw this on my SQL server 2008 R2.

I tried removing the replication using "EXEC sp_removedbreplication" but it did not work. In fact I never had replication enabled, althugh there...

@MDTech.us_MAN

I am guessing this is a shared hosting solution. In that you would not have any access to the server configuration.

I would suggest that you get in touch with you...

use mydb

exec sp_helprotect

This should give u object level permissions on that DB for all users.

copy paste to excel and filter out to original user.

create a user role and...

cant you just simply create 2 schedules, 1 for the PM hours and 2nd for the AM hours. each one of them can have its own occurs overy 'x' hours,...

Just out of curiosity. have you included the starttime and endtime columns in the trace.

If you havent got that then it aint going to work. Its always a good...

yes

the server is a different one with a different name altogether, I agree with you that the maintenance plans will take a hit. We are actually going to have...

Master has information about all databases, where the files are located, the logins, permissions and large bunch of other info......

now when u say rebuild, what do you mean.... do you...

Typically if you try to restore across versions it will throw an error.

As mentioned in the earlier posts, the reason why this is not possible is that we have have...

Technically there is no problem as to why u cannot do Mirroring on the same database instance.

Secondly since it is your system and for test purpose u can go...

oops silly mistake.....

i never had tried to take a backup anyway.

so basically as gail has also agreed, dont restart SQL Server/ reinitialize the Tempdb get more space instead.

If...

Did u try removing the 'as' ?

you can configure replication as a publisher, distributor and sunscriber on the same instance of SQL Server. Technically there is no problem as to why you cannot do it. The...

probably one of your transactions is a bulk transaction and takes a lot space.thats why u see a reoccuring problem. Do u have any other drive. If yes, disable autogrowth,...

lets say as a DBA I know a new customer addition transaction should affect the "customer master" table and the "customer detail" table, and for every master entry the functional...