Viewing 15 posts - 46 through 60 (of 1,334 total)
Note that in log shipping when the log file is being restored you will not be able to read the data as the restore will acquire a exclusive lock in...
February 28, 2008 at 5:23 pm
Yes everytime your job sees and error it will stop automatically reporting failure. Since you are in 2000 create a DTS package and then schedule the package.
February 28, 2008 at 5:22 pm
Anything that starts with _WA_Sys is system created index which s used ofr faster retrival by sql server. you need to see if they stil exists and delte them as...
February 28, 2008 at 5:20 pm
you can query the backset and backupmediaset to find you fired the backup and the take necessary actions. And check if there is a MP created to backup your databases...
February 28, 2008 at 5:19 pm
When you said that you traced to find out the procedure created would can also trace the source from where the command was fired so that youcan easily find the...
February 28, 2008 at 5:17 pm
So You have sorted this problem out with changing to a domain account.
February 28, 2008 at 5:09 pm
What if your database grows to the maximum size in a single transaction so the plan can be better have a tlog backup every 1 hour in production hours atleast.
February 28, 2008 at 4:53 pm
Create the database, create the datafiles and script the tables and place them in the filegroups and then move the data. hope this should be an easy solution for you.
February 28, 2008 at 4:51 pm
BPA is used to analyze and tell you what security changes that your server lags and also the basic maintenance tasks. it tell about the permissions, service account and lot....
February 28, 2008 at 4:48 pm
I prefer detach/attache as this will not leave me losing any transaction in the database after it has been backed up. so plan your startergy.
February 28, 2008 at 4:47 pm
You can use this query thats given below too.
http://www.sql-articles.com/index.php?page=Scripts/sp_details_tbl.php
February 28, 2008 at 4:45 pm
Do you meant to say that everytime the procedure is called its created and executed.
February 28, 2008 at 4:43 pm
Yes checkdb with repair puts the databse in single user mode. you need to plan for a downtime and do that. Also remember that restoring a database from a corrupted...
February 28, 2008 at 11:26 am
You can use replication for your needs.
February 28, 2008 at 11:20 am
Do a detach and attache method. This should be fine And after migration make your database to compatability level 90 to get the features of 2005. this method involves some...
February 28, 2008 at 11:18 am
Viewing 15 posts - 46 through 60 (of 1,334 total)