57 reputation
3
bio website
location Testelt, Belgium
age 28
visits member for 2 years, 2 months
seen Jun 18 at 9:32

Oct
7
awarded  Supporter
Oct
7
accepted Why does @@dbts increase after backup/restore?
Oct
4
comment Why does @@dbts increase after backup/restore?
We use a BI environment that operates on a backup of our live database. The backup is made every night. The timestamps are used for incremental updates in the BI environment. So when @@dbts increases after a restore, sometimes data ends up missing... The fundamentals of how this system works can't be changed for the moment.
Oct
4
asked Why does @@dbts increase after backup/restore?
Jun
29
accepted Would it be possible/wise to execute 2 parallel restores from a single backup?
Jun
27
comment Would it be possible/wise to execute 2 parallel restores from a single backup?
The backup file is located in a network folder, so it is accessible to both servers. What about performance? Will it be faster than restoring sequential?
Jun
27
comment Would it be possible/wise to execute 2 parallel restores from a single backup?
I know that there are better solutions available, but for now I should get this to work.
Jun
27
asked Would it be possible/wise to execute 2 parallel restores from a single backup?
Jun
4
awarded  Scholar
Jun
4
accepted Can I do something like RESTORE DATABASE <server>.<databasename>?
Jun
1
awarded  Student
Jun
1
comment Can I do something like RESTORE DATABASE <server>.<databasename>?
While reading documentation on OPENQUERY, I found that you can also execute a stored procedure on a linked server. So if I were to put my restore script in a stored procedure, this should have the same result?
Jun
1
asked Can I do something like RESTORE DATABASE <server>.<databasename>?