I suggest contacting Quest. Some 3rd party tools restore at table level. It may depend on the version installed and system specifications.

• This reply was modified 3 years, 3 months ago by homebrew01.

3rd party tools should have a free trial period, so you can compare to your existing process.

If you really want faster backup/restore options - then you really need to work with your SAN vendor.  Almost all of them have snapshot capabilities which can perform a...

• This reply was modified 3 years, 3 months ago by homebrew01.
• This reply was modified 3 years, 3 months ago by homebrew01.

Thanks for the update.

Apparently not. Still...

• This reply was modified 3 years, 3 months ago by homebrew01.

You may be able to temporarily set the server date back a week or 2 to "trick" SQL into thinking it hasn't expired.

Then take full backups, and upgrade to a...

• This reply was modified 3 years, 3 months ago by homebrew01.

How big are the databases ?

SQL Replication is a built in tool. It works at the table level. Do you want the entire databases regularly, or just specific tables ?

Can the client servers and your...

• This reply was modified 3 years, 3 months ago by homebrew01.

Your requirements are not clearly explained.

To generate table schema, right click your table(s) then --> Script Table as --> Create to -->

If the database is FULL recovery, would it help to run t-log backups frequently during the process, to prevent a huge t-log ?

I  thought a restored database uses the same space as the original database.

Yes, I have seen...

Any luck fixing it ?

A Differential captures the Changes to a database since the last Full backup. It has no value by itself. It is used to restore a database back to that point

I...