Viewing 15 posts - 76 through 90 (of 98 total)
is this a user database ?
Did you created that database?
Can you provide me its name if it is not created by you .
This is the list of all the posssible...
January 12, 2011 at 3:31 am
kasaranenikiran-725528 (1/12/2011)
DOes it belong to the Replication ???
No, i don;t think it has anything to do with replication. Replication does not hide the database.
It is realy strange because unless you...
January 12, 2011 at 1:01 am
kasaranenikiran-725528 (1/12/2011)
How do I check if the DB is OFFLINE ??
run the below command
select name , database_id , state_desc from sys.databases
it will list out all the...
January 12, 2011 at 12:31 am
shikha.in.2 (1/11/2011)
if db crashses then how we recover backup and log file with proper reason Please.
I don;t understand what are you trying to say by this statement..
/* How we recover...
January 12, 2011 at 12:10 am
beejug1983 (1/11/2011)
how can I allocate part of memory to this SELECT statement
I don;t think there is any way in sql server in any version\Edtion which will allow to allocate...
January 11, 2011 at 11:42 pm
Dj463 (1/11/2011Is Transactional replication a viable solution for Archiving the data?
yes it can be a solution for you. but as you mentioned that if we avoid delete statements not...
January 11, 2011 at 11:25 pm
Dj463 (1/11/2011)
Well as i said full backup of the database is taken daily, my concern is if i take transactional log backup monthly will it contain all...
January 11, 2011 at 10:29 pm
Dj463 (1/11/2011)
Should the archive database be on same instance (or) separate instance of same server (or) on separate server.
For Archiving a database there is no specific limitation that where your...
January 11, 2011 at 10:21 pm
I personally don't think what you have mentioned would be a right strategy as far as backup is concerned.
This will not solve your purpose rather it will make your database...
January 11, 2011 at 10:01 pm
No shrinking is not at all part of a full backup by default.
Neither it is an option in backup.
Shrinking of a database actually is a totally different process in...
January 11, 2011 at 8:46 pm
mishka-723908 (8/6/2010)
I am having an issue where I am getting multiple(two) plans for the same Stored Procedure.
I dont know the reason for the duplication. I can manually re-create it, but...
August 10, 2010 at 5:01 am
vamshikrishnaeee (8/10/2010)
I have a table workcachedetail with 40 million rows which has 8 columns.We decided to partition the table.Most of the queries in our environment uses 4 columns in the...
August 10, 2010 at 4:30 am
I don't think that we can partition based on columns.
As far table partitioning is concerned , we can partition the data horizontally not vertically,
What you are expecting is very much...
August 10, 2010 at 4:28 am
Hi dba_2005,
So far i understood your query you want to get an email if any of your job fails.
For this you should do the following assuming you are using 2005...
July 27, 2010 at 2:48 am
pls. be a little more specific about your requirement.
After reading out your query it seems you want a stand by box where you get all the changes immediately after you...
July 27, 2010 at 1:45 am
Viewing 15 posts - 76 through 90 (of 98 total)