LDF

Recovering lost SQL Server 2000 data

I lost a LDF file for SQL server 2000 -- but I have the MDF. How can I recover my data?

How can I reduce the size of an LDF file?

How can I reduce the size of an LDF file?

Attaching MDF and LDF files to SQL Server 2005

I have MDF and LDF files with different modified dates. How could I attach these to SQL Server 2005?

A job to move database files from one server to different server

Hi I have job which creates databases based on month in analysis services which contains cubes in the databases. I need to create a job to move the database ldf and mdf files of the previous months removing the database from the server if the month changes to next month. The database files should...

LDF size reduction

How can reduce *.LDF size i have run the command dbcc shrinkfile (Filename,1) but could not reduced.

SQL Server Error while creating db from DUMP

Hi, We get the following error while trying to create a new db from a dump which contains the MDF and LDF files. Appreciate if anyone could let me know on what could be the reason for this error. The operating system returned error 38(Reached the end of the file.) to SQL Server during a read at...