Viewing 7 posts - 1 through 7 (of 7 total)
Hi,
I need to create a copy of that database on other Server.
I tried DBCC SHRINKFILE, but it doesn't shrink the file as there is no free space available in the...
July 5, 2011 at 1:00 am
Hi,
In MOSS 2007, probably the one who configured it has enabled complete logging.
There are 2 options in MOSS 2007, one where in complete logging & second partial .
Sp probably...
April 30, 2010 at 12:39 am
If there are 2 backup files, they'll be same or of different versions.
restore the lastest database backup file, it may take time (more than 1 hour) to restore if your...
June 5, 2009 at 4:42 am
The backup can be taken from client directly, by using SSMS.
June 2, 2009 at 10:52 pm
Thanks but main probelem is how will job 2 come to know that job 1 is completed, it cannot be scheduled because if job 1 take more than normal time...
June 2, 2009 at 5:37 am
When you take backup next time donot check the option of "copy the tail of transaction log and leave database in restoring mode".
June 2, 2009 at 4:50 am
check the size of Log files and shrink them either by SSMS
or by using this query
dbcc shrinkfile ( logical file name,target size)
Also make sure there are no...
June 2, 2009 at 4:18 am
Viewing 7 posts - 1 through 7 (of 7 total)