Hi Davud, don't you think you might have a few too many rows in one table for SQL
Server? Is there any reason why you would not want to partition the
table or not want to create some sort of archive....I would be
surprised if you can get any kind of reasonable performance for any
reasonable operations on 2 billions rows.....and how long does it take
to back up? Or are you not backing it up?.. ;-)
RE: Backups have Shadow Copy Problems ...Active backup destination: File ...Reason: The process cannot access the file because it is being used by ...Warning: Unable to open "C:\Documents and Settings\Administrator\Local ... Warning: Unable to open "C:\Program Files\Microsoft SQL... (microsoft.public.windows.server.sbs)
Re: Upgrade Access backend to SQL database ... end to SQL tables rather than the current Access table structure. ... If the database is well designed in Access and then upgraded to SQL Server... It's a five-star book at Amazon.com for a very good reason.... (microsoft.public.access.modulesdaovba)
RE: Backups have Shadow Copy Problems ... recovery model of the SQL Server database to Simple. ...Warning: Unable to open "C:\Program Files\Microsoft SQL ...Reason: The process cannot access the file because it is being used by ...Backup completed on 2/14/2006 at 3:39 PM. ... (microsoft.public.windows.server.sbs)
[Full-Disclosure] RE: SQL Slammer doing the rounds again? ... I was assuming that this was the only reason the poor netadmin ... the web designers and their choices; I can't speak to the issues ...Security Business Unit...SQL Slammer doing the rounds again? ... (Full-Disclosure)
Re: SQL/ADE Object Security ... The reason Win 2k is ... more secure than NT4 is that NT4 has been around far longer, ... How many years has SQL 2k been around now? ...Server instance is installed, either now or in the future. ... (microsoft.public.sqlserver.security)
