Viewing 15 posts - 631 through 645 (of 860 total)
blue_inelush (3/26/2010)
Are you 100% positive there is no process working on that db?
Have you looked in Activity Monitor if there is no process there?
Have you tried to detach the db...
March 26, 2010 at 1:32 am
Gail and myself already asked the error logs and application logs.If you give those thing we ll try to help u.
March 26, 2010 at 12:31 am
Restarting sql server (or) detach and attach the db will not bring the database online
March 26, 2010 at 12:28 am
charipg (3/26/2010)
I have restarted the services then tried to detach then i got the same error "The data base is in use".
charipg,
Read my previous replay.
March 26, 2010 at 12:27 am
repent_kog_is_near (3/24/2010)
if I take my DB offline, will I lose the DMV historical data?Dan
Answer is Yes.
March 25, 2010 at 1:12 am
sandhyarao49 (3/24/2010)
Frequently one of our production server is experiencing high CPU usage, it almost reached 80-90 % at times.
Can anyone let me know from the sql server point of...
March 25, 2010 at 1:01 am
charipg (3/24/2010)
no errors in errorlog.
Check the system event viewer application error logs.
March 25, 2010 at 12:46 am
Nitin Gupta - SQL DBA (3/25/2010)
If you are sure that, there is no recovery is started from your end and if the environment is not associated with production In such...
March 25, 2010 at 12:45 am
charipg (3/24/2010)
The database is in recovery mode since 3months.so i am not able find any logs in sqlserverlog.There is enough space in the drive.
Who's responsible for the server ? U.
since...
March 25, 2010 at 12:26 am
subha.msc2007 (3/24/2010)
ok sir,can we detach the System databases ?
Read the link
March 24, 2010 at 8:18 am
subha.msc2007 (3/24/2010)
hai,plz help us.......
Subha
What type of help you need ?
Give me more info...
March 24, 2010 at 5:07 am
Manikandan Subramani (3/23/2010)
In one of my SQL jobs i am dropping TEXTCATALOG created for a database and while creating the TEXTCATALOG again, i get the error
"sysft_EIS_FullTextCatalog' cannot be...
March 24, 2010 at 3:42 am
charipg (3/24/2010)
Database is in recovery status.
I dont know why it is showing recovery status.
I tried to do detach,offline and drop then every time i am getting error as "The database...
March 24, 2010 at 3:32 am
rockingadmin (3/24/2010)
Yeah definitely i will take backups of all databases. then i will work..Thank you very much
Regards,
Rock..
Ur welcome.
March 24, 2010 at 2:59 am
Try this
set @Cmd = N'copy "c:\SQLOldFiles\' + @FileName+ '" "c:\SQLNewFiles\"'
March 24, 2010 at 1:08 am
Viewing 15 posts - 631 through 645 (of 860 total)