Database Reference
In-Depth Information
How to do it...
To design and refresh a reporting database, you will need to complete the following steps on
the production SQL Server instance:
1.
Unmask the Logical Unit Number (LUN) on the disks where the Production database
is stored. (Refer to the hardware vendor's manual).
2.
Mount each reporting volume and mark it as read-write.
3.
Obtain the disk volume information. Logon remotely to the server and open a
command prompt window to run the following:
DiskPart
list volumes
4.
Use the
DiskPart
utility to mount the volumes, then on that command prompt
window run the following:
DISKPART
5. The
DiskPart
utility will open a prompt for you to enter the following commands:
DISKPART> select volume=<drive-number>
DISKPART> assign letter=<drive-letter>
DISKPART> attribute clear readonly
DISKPART> exit
The
<drive-number>
is the volume number assigned by the
Windows operating system.
The
<drive-letter>
is the letter assigned to the reporting volume.
6. To ensure that data files are accessible and disks are correctly mounted, list the
contents of the directory using the following command from the command prompt:
DIR <drive-letter>:\<database directory>
7.
As we are refreshing an existing reporting database, attach the database to that
server instance using SSMS. On Query Editor, enter the following TSQL statements:
ALTER DATABASE AdventureWorks2008R2 SET READ_WRITE
GO
ALTER DATABASE AdventureWorks2008R2
SET RECOVERY FULL, PAGE_VERIFY CHECKSUM;
GO
8.
Detach the database from that server instance using the
sp_detach_db
statement
from Query Editor.
Search WWH ::
Custom Search