emmanuel.constant (7/31/2012)

---

I did discover that I have the Win2008 server which host the SQL Server 2008 on one domain and I'm attempting to access it from a client PC from...

I have seen your attached error snapshot and have assumed two possiblities:

1. TCP\IP Services seems to be disabled. Which is not allowing you to handshake with remote server.

2. Please type...

http://www.simple-talk.com/sql/t-sql-programming/identity-columns/

I too totally agree with Gail, but if the DB size is in TB than it will be time consuming testing !

And If we have multiple DB to test...

Thanks for the reply !

Restore is possible if I have single or couple of db, but if I have many db than its not possible to restore each db and...

We can not go with restore option if backup size is bigger each time... Is RESTORE ONLY and With CHECKSUM are 100% sure to validate backup files ?

Thanx Abel for quick reply. So we can not install MSSQL on linux\unix platform but we can access MSSQL from linux\unix platform. Am I correct ?

Thanks Peryy and savethytrees !

Yes, the given query for log shipping is very much useful. But I am asking in general that if I want to know that which backup set was last restored,...

Your issue is best explain bu microsoft support at

http://support.microsoft.com/kb/811889

Jim_K (7/11/2012)

---

Out of curiosity, are inserts "cheaper" in terms of time for a heap versus a clustered index?

To extend the OP's metaphor, it's real easy to toss another book on...

Thanks Perry for the quick reply,

exec sp_help_log_shipping_secondary_database

@secondary_database = 'yourdatabase'

Above query can be used only for database of log shipping. If I dont have log shipping, than how I can...

For the testing purpose and learning I follow the link:

http://www.databasejournal.com/features/mssql/article.php/3828341/Database-Mirroring-in-SQL-Server-2008.htm

and my mirroring test setup is working fine. Go through it, it might help you.

Is there any query or any DBCC or any DMV check to find out which transaction log backup last restored?

I can see on message column, "skipped log file" and "searching through log backup to restore". According to me this indicates that some transaction files are missing and thats why...