Hi 

I  have used attach detach many a times on other servers and never ever faced such situation where the filelog file is going into data folder( and not in...

Thanks Steve

will work on dbcc next time , but right now i am just finding out why log files are going to data and not into log folder whihc i...

Hi

No actually i renamed the ldf file so that attach recreates the trn file and i can  save some space in disk as the log was  around 5 GB.

Regards

Deepa

Hi All

i faced a strange behaviour for attach /detaach and reattach .

the database mdf files are under data folder and ldf goes to logs folder , the detach happens successfull...

hi all

i do have same issue at sql 2000server

having 60 database

logfiles keep on growing i am doing  backup as follows

daily full

trn log at 12 am , pm...

Hi All

Thanks for all inputs

alternatively i tried dbcc shrinkfile and yes it has to be run twice and i oberved teh trn log file reduced to mentioned size.

but question...

Thanks for the response.

But do you or anybody else working this way practically?

Deepa

Does that mean the MS replication is far sucecessful to choose as a long term soltion.

If i have enable Cont. Trans repliccation b/w 2 SQL server(for one Databses around 2...

Hi All

I have tried again and agian but failed.

But whatb i had was the one prev. day backup of msdb with me , I tried to restore it after master...

Hi Andy

I am already using with move option for logs.

Pls note that system databases are in default dir c;\mssql7\data only

The problems is that error--in msdb restore I think

RESTORE...

Hi All

we are also currently depending upon Veritas Backup exec to do all backups of sql dbs .

veritas also gives off the line backup and alos mailing facilities like...

Thanks, Though I am still reserching more...

No answer as yet with me too

Thanks Again

Deepa

Thanks..

So i will implement this on 1-2 Dbs and observe if theTrans log file comes down to resonable size ...

Thanks again

may need further help..

Cheers

Deepa

Hi

So the conclusion is:

if i dont need any trnsaction log backup--

1) change recovery option to : Simple

2) shedule the trans log backup

this way the log...

Hi

Currently my database recovry is set as Full

also I am taking complete Databse backup of all Dbs

weekly.

No trans log backup is scheduled in this job...

Pls...