Thanks Gianluca

That means the insertion of 10 will not be logged instead marked modified.

Then what if a crash occurs after that 10 insertion. Is it possible to restore from a...

Hi Beckham,

MSDb database contains all jobs,schedule task information so when you restore MSDB from another server the old jobs you have configured will be replaced by the new one which...

That may occur because those filegroups need that much space for proper functioning ..

Please check others advise too.

SQL 2000 all pages are verified for verifying the backup.

In 2005 it uses checksum

Thanks for the reply.

We are using x64 windows server 2003 and SQL Server 2005 Enterprise Edition.

Can anyone please tell me the memory characteristics and management of SQL Server?

We are...

Thank you very much jamie

Are you a DBA? What exactly is your requirement?

You need a full backup to restore the lost data ..

Check your backup file using RESTORE VERIFYONLY option.

So many tools are available .From my personal experience try Toad 4.0 trial version is available free of cost

Stored procedures are in Database and in your case it will fail as the linked database doesn't have the same procedure defined there.

Taking backups wont shrink the log files. that is the reason why they grew.

You have to run the dbcc shrinkfile or shrinkdatabase command to reduce the physical size of the...

Learning something is not bad and if u already have SP ,Triggers functions etc then go ahead and learn cursor 🙂 so that u can swithc between a developement DBA...

Can you please tell me what exactly is your requirement?

Ya as Gursethi said the problem is mainly because of improper client installation or deletion of files related to taht mostly .NET

Can you view the name of that database in SSMS?