1) you have to have a master key created for TDE to work, however, can any master key be created on a SQL instance for any database to be encrypted...
1) how do you extend a database data file onto another drive, when the drive is running out of disk space? i heard there is a way of doing this via a...
After reading about TDE and restoring an encrypted database on another server, can anyone please answer the following?: 1) When I restore an...
I am rebuilding one node which usually has the principle database on. This means I have to re-install SQL and setup Database mirroring. The database...
how can i temporarily stop tempdb usage on alive server, so i can shrink the tempdb files, and not restart the sql server service? tempdb is used a...
the max server memory setting is 6.5 GB. 1) how can i determine how much exactly is being used by the sql server processes only? for example 6.5 GB...
someone told me that sql server database backup in sql server 2005 and later do not truncate the transaction log. is this true? (i didn't think it...
I have run the below code to change the standby readonly database to read_write and get the below error - why?: USE [master] set...
hi i'm trying to amend the database growth settings, but as the standy by dataabse is read only i can't. any ideas how to do this? here is the...
hi everyone - i have spotted the following errors when running dbcc checkdb on some databases: msg: 8966, 8921, 8909, 2533, 926, 5269, 824, 823. i...
is it possible to setup an alert on PAGE_VERIFY_CHECKSUM for damaged pages?
1) can database on principal be backed up with FULL database backup without affecting LSN transaction log sequence? 2) can TRANSACTION LOG backup of...
can performance monitor send notifications on % used of transaction logs?
will SSIS on principal after a DB mirror failover to the mirror? or will you have to setup a copy of SSIS packages on the mirror as well?
do cluster failovers 'auto' restart sql server sevices on 2005 and 2008?
1) Can I take a full backup of the database on principal, without worrying about interrupting the LSN transaction log sequence? I understand all...
Hi - I can't get db mail working or delete the db mail queues. I've restarted sql server and sql server agent service. db mail stored procedures is...
I have checked the database mirror alert: 'DB State:Mirroring State Changes'. This alert runs query 'SELECT * from DATABASE_MIRRORING_STATE_CHANGE'....
i have setup database mirror job and changed the job to use an escape macro - and i have selected the option to 'Replace tokens for all job responses...
I have to correct a job that uses a WMI token. I have read the documentation and plan to do the following: 1) Enable token by selecting the option...
Separate names with a comma.
