sql server minus one day I have a server with SQL Server 2008 R2 installed in it. This server is used as a D -1 Database, in other words, the database it is one day behind from production server.

The problem is that my production database has more than 300GB and the daily restore is becoming an issue for the team who needs this server, because the job isn't finished before the morning day.

Is there some solution that replace the daily full backup, some kind of replication with delay ?
Instead of restoring a daily full backup, you could:


Take weekly full backups of production, restoring them to the D-1 server the next day.
Take daily differential backups of production, restoring them to the D-1 server the following day.


The daily restores from the differential backup will be much faster than restoring the entire database each day.

I'd advise against using replication for this; as @Mark Storey-Smith said, you will now have two problems to manage instead of one.