Do you have access to this DB?

Fill factor is the amount of data filled up in the pages. if the table is static then a Fill factor of 100 is perfect, thereby all the pages are...

Check your servers authentication mode? Also make sure your login exists on the server you are trying to connect. I would say a login by your name under SQL...

Leo:

Simple recovery can only be used if you can afford to lose all the data changes since the last backup..:w00t:

Simple recovery does not require Transaction Log backups..:)

If you want to...

Jeff...correct me if I am wrong 🙂

After the shrink, as users add rows etc in the database, the file has to grow again.

Growing a database file is an expensive...

Rajaa, what you are seeing is not strange, heres why

In SP4 we are able to determine the blocking spid for latch waits when the blocking spid holds the latch in...

Litespeed supports advanced compression, faster restores and also Object level recovery. I am not sure about the cost effectiveness though..

Thanks!!

Good Poll topic dude..I wouldn't wanna vote before Nov 4th though :hehe:

Ok, quick answer to your question:

Differential backup has all the changes made to your database since the time there...

Install SQL Server 2005 and on the actual Database server. If you want many a connections then use the TERMINAL SERVICES server and install Client here.

You can connect as many...

Use IZArc for compression maybe. One more I would like to suggest is if you copy over the network then it would take 40 more hours as you mentioned. Why...

Well the backup sets are not displayed by default. You have to direct SQL server to look up for the backup file. Here you need to show it the type...

Good question Gail..:cool:

mohini why would you need to take the DB offline :hehe:. If you only want to restrict access then go ahead and set it in Single User mode...

Yes, server B allowas remote access.

Now, when I restore the Db on server B, do the logins automatically access the schemas for the newly restored database for I created the...

Create separate maintenance plans for full backups and transaction log backups and see what you find 😎

Thanks!!

Well run this OSQL script locally and then make sure the script is located with the same name on the said directory...

Thanks!!