Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with sql-server-2008-r2
Search options not deleted
user 6390
SQL Server 2008 R2 (major build version 10.50.xxxx). Please also tag with sql-server.
0
votes
Semi-Annual archiving of SQL Server database
Use Database Snapshots
Use SQL Server's built-in Database Snapshot functionality. In the article on Typical Uses of Database Snapshots, the following is listed as a common use case:
Reasons to take …
- 432
3
votes
3
answers
644
views
Semi-Annual archiving of SQL Server database
Twice a year we create a static, archived subset of our production database. The newly created database contains roughly half of the tables as the production db (log/audit tables, etc. are not copied …
- 432
0
votes
Semi-Annual archiving of SQL Server database
Create Table Structure --> Fill Tables --> Add Security
Use SSMS to generate scripts to create table structures.
Change the USE [ProductionDb] at top of each script to USE [ArchiveDb2011B].
Create t …
- 432
3
votes
Semi-Annual archiving of SQL Server database
Restore From Backup --> [Drop Unused Tables]
Perform a full backup of database ProductionDb.
Restore from backup to database ArchiveDb2011B.
[optional] Drop unnecessary tables.
Set database ArchiveD …
- 432
5
votes
Connection to localhost dramatically slower than to network server
Try enabling TCP/IP on your local instance:
Open SQL Server Configuration Manager (mmc.exe -> [Ctl] + [M] -> Add "SQL Server Configuration Manager" snap-in)
Expand "SQL Server Network Configuration" …
- 432