Re: Restoring a Single Table

1. Yes, you can restore single table without affecting other tables while
keeping the rest of database online if
- other tables are not depend on this table
- this table (or just partition to be restored) lives in a separate
filegroup
- you're using Enterprise Edition ;-)

Of course, you can always do the same on any edition (regardless of
physically data placement) by (entirely) replace data in (recreated) table
with data from a database snapshot or from recent backup (which you may
restore under another name on the same or another instance of SQL Server)

2. There are many HA features in SQL Server 2005: failover clustering, log
shipping, database mirroring (not supported in current release but maybe
will after sp1)..., but none of them can be supported using single database,
of course... %-\

--
WBR, Evergray
--
Words mean nothing...


"Francis Reed" <francis@xxxxxxxxxxxxx> wrote in message
news:uzDD6psQGHA.4452@xxxxxxxxxxxxxxxxxxxxxxx
Hi

I'm working for an online university, and we are currently in the process
of redesigning our portal website. We were thinking of using a single
database to store content, quizzes, and assignments coming from multiple
courses, as well as user accounts and security. The reason for this, is
that it simplifies generating reports for students taking multiple courses
(eg.:, student transcript), teachers requesting reports (gradebook), etc.
During the design process, we asked how can sql server 2005 maintain high
availability? Also, what if only a single table got accidently deleted, or
currupted. How can we restore that table without affecting other tables,
and in the process keep the database online while restoring? So here's my
question, is there a way to restore a single table without affecting other
tables in the same database.

Secondly, is there a way of maintaining high availability with a single
huge database with lots of users commiting changes (eg, students writing
quizzes, teachers adding content, admin staff moderating forums)?

Thanks in advance
Francis



.

Relevant Pages

  • Re: Backend Exchange migrate to New Hardware (Server)
    ... Exchange mailbox stores and Exchange public folder stores. ... When you use Backup to restore Exchange databases, ... Storage Engine to restore Exchange database files and their ...
    (microsoft.public.exchange.setup)
  • Backup and Restore Files
    ... What is the best way to backup and restore a runtime database file? ... pszDisplayName As String ...
    (microsoft.public.access.gettingstarted)
  • RE: Restore public folders and companyweb
    ... > where the backup of the database. ... Before you can start to restore the SharePoint Services databases, ... > Microsoft CSS Online Newsgroup Support ... > This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • Re: Transaction Log ??
    ... we used to simplify our database restore process: ... every database got their respective backup folder. ... -- get logFileName, FirstLSN, LastLSN list ...
    (microsoft.public.sqlserver.security)
  • Re: PARTIAL SQL Server RESTOREs
    ... DROP DATABASE mywind_part ... ALTER DATABASE mywind ADD FILEGROUP new_customers ... -- A full database backup is performed. ... RESTORE FILELISTONLY lists the database ...
    (microsoft.public.sqlserver.server)
Quantcast