Initializing Pages 
Author Message
 Initializing Pages

Is the backup server faster at intializing(zeroing) pages than the
dataserver for example, if I have a backup of a 1GB DB with
no data allocted could it be faster to create DB for load and
then load DB  with backup server versus a straight create DB?

TIA, Dave W.



Sat, 18 Jul 1998 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. snap-in failed to initialize and Application failed to initialize(0xc0000142

2. snap-in failed to initialize and Application failed to initialize(0xc0000142)

3. snap-in failed to initialize and Application failed to initialize

4. Statistics Page or Distribution Page for MS SQLSERVER

5. how to run a dts from a web page like an asp.net page

6. how to query page by page

7. Multiple record recordsset w/Page Breaks in ASP Pages

8. How to read phisical page (not DBCC PAGE)?

9. Pages/sec, Page Reads/sec

10. SQL 6.5 Confilicting Performance: Memory-Page Faults: High AND Cache-Avg Free Page Scan High

11. Soft pages faults vs hard page faults


 
Powered by phpBB® Forum Software