June 9, 2014 at 5:28 am
My database is a stand alone, The database was not backup for past 2 years.
The data will be inserted and deleted periodically,so there was no necessary to backup database till data, but i have question will Database backup help in performance ?
Performance like insert/ select / delete is little bit fast when without backup VS with backup
will there be any improvement?
Thanks!
June 9, 2014 at 5:43 am
I have to ask why you have a database that hasn't been backed up in 2 years. I don't know what you mean by it being "stand alone", but if it contains any data worth saving, then it should certainly be backed up.
Backing it up will also mark the pages in the transaction log as backed up, so they'll be available for reuse. That means it won't have to grow and consume more disk space.
BTW, once you back it up for the first time, make sure you have a viable backup by seeing if you can restore it somewhere. A backup is useless if you can't use it to restore your database.
June 9, 2014 at 5:50 am
Stand alone is once the database is created and configured it is no longer in sight of developer.
Say it is been shipped to customer.
Database is in simple recovery model.
the database restoration will not happen.
Data loss is accepted.
June 9, 2014 at 8:22 am
Ed Wagner (6/9/2014)
Backing it up will also mark the pages in the transaction log as backed up, so they'll be available for reuse. That means it won't have to grow and consume more disk space.
It will not. Full backups DO NOT truncate the transaction log or mark any portions of the log as reusable.
Backups do not improve performance. They are there to allow the DB to be recovered if necessary.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 9, 2014 at 8:23 am
yuvipoy (6/9/2014)
the database restoration will not happen.Data loss is accepted.
So what happens if there's a drive failure? Do you tell the customer 'Tough luck, you've lost everything'?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 9, 2014 at 8:32 am
GilaMonster (6/9/2014)
Ed Wagner (6/9/2014)
Backing it up will also mark the pages in the transaction log as backed up, so they'll be available for reuse. That means it won't have to grow and consume more disk space.It will not. Full backups DO NOT truncate the transaction log or mark any portions of the log as reusable.
Backups do not improve performance. They are there to allow the DB to be recovered if necessary.
Oops. :blush: That's a log backup. I stand corrected. Thanks Gail.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply