either use this things

shrink tempdb,

or

detach the file and attach with a new one with 0 bytes

or still you cant do

just restart the sql services, everything will be refreshed.

We backup our db of size 60Gb directly to a remote network drive, it takes time compare to the local drive, create a maintainace plan of your backup and i...

use sp_renamedb

http://msdn.microsoft.com/en-us/library/ms186217.aspx

I tried to reinitilize the subscriptions but everytime is having the same problem.

my mistake, we dont want to touch our production server, so instead of mirroring from production server at site A, i will do both the mirroring and replication from the...

Thank a lot,

i can do mirroring from production server at site A to DR site production server,

and create a subsriber from site A report server to DR site report server

And...

Mike,

I have only one problem before implementing mirroring in my case, since the database would be in restoring mode on the mirror side i cannot replicate it to the DR...

Thanks,

i am planning for a DR for our production at site A actually, here the production has publisher which is used for report server. we want a setup like this...

A, B and C are all separate servers.

steve, do you know how to allow the ports to work on separate WANs i guess this is the only problem, and i dont have any idea about it. i...

i checked the TCP they are fine, i did the netstat -abn and the ports are available

I resolved it, here it was the problem as the user wasnt correctly mapped with the read permissions. Thanks

Thanks a lot guys, I am now able to do it through network. I was giving the path from the address bar from my computer, But now when i went...

can i delete the backup file on the local system and then restore it from the network drive, i know we can do this, but i dont know how to...

so what do i need to do, i dont have that much free space available.