Hi

I have used robocopy extensively and I think it is one the best ways to copy a file over the network.

Pls check you network utilization from the source...

Thanks D: for the link.

Even I had a similar situation in our production environment we were using mount points and the disk monitoring was not showing the actual space used:

...

Do you have a backup of this database? if yes then you can restore it:)

I found the solution for this problem:)

There are few things that I did to make it work from SQL Server 2005 to SQL Server 2000:

Note - 1. While...

Yes there was some issues with 2005 schema like some of the tables were owned by schema "Person" so I created a schema with the same name in 2000 and...

Hi David,

Wonderful article and thanks for putting it, I had similar situations were I had issues with PK violations at the subscriber.

I recently tried to setup transactional repl...

Thanks for the reply!!!

Thanks Steve. Guess what I told this to an interview but he still wanted to see what else we can do? I was stuck:)

I think there are some system DMVs...

Thanks Steve! I was thinking that if it a clustered server then each individual instance will have its own IP address.

Regards,

Is your sql server clustered? or it is a standalone default or named instance?

For issues with backups taken from other locations please use Restore script with "move" option. Check booksonline for exact syntax.

Reply to:mdaniel

---------------

Do we need to create that custom page using c# and then link the reports to it. Any help in creating a sample page would help a lot...

Thanks for the response:

Im a newbie to SSRS. My manager wants to me to build a report but he doesnt want me to use the default "Report Manager Page"...

The backup set depends on how you have used the backup file.

Example: only FullBackup.BAK or DifferentialBackup.BAK or TransactionalBackup.BAK or TRN.

If you have used GUI in SQL 2000 and...

If you are restoring in a different server and if it is an ongoing process I would recommend LOG Shipping process to be setup.

Its easy to manage and you...