Syntax for the 2nd path doesn't look correct.

Is there a connection problem to wherever the target backup folder is ?

This sounds like you will be taking the old server off line.

Can you clarify your situation?

Timing ?

Business...

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

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, 9 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, 9 months ago by homebrew01.
• This reply was modified 3 years, 9 months ago by homebrew01.

Thanks for the update.

Apparently not. Still...

• This reply was modified 3 years, 10 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, 10 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, 10 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.