The lack of standardized file naming exacerbated the problem, as did the lack of centralized storage of files and an agreed on file organizational structure. Communicating receipt and avail ability of project information to team members, including the creation of a parallel database and the identification of an information. Strategic employee onboarding software from SilkRoad Technology gives you the ability to keep your employees engaged and activated through our continuous onboarding process. Learn more about talent management technology on our website.

• Access Database Files

I have used tsql to detach a database like this:

I then made use of PHP to rename the physical files. I was able to rename the mdf file but not the ldf file! I even tried a dos command REN but that didn't work for the ldf file either!

I wanted to ask, is there something special about the physical log files that allow it not to be renamed?

Is there a better way of doing this?

Thanks all

AbsAbs

5 Answers

Detach the Database, Rename the files, Attach it again.

You can do it using an ALTER DATABASE statement - like this:

You need to modify each file separately, e.g. if you have multiple data files, you need to modify each of those.

For details, see the Technet documentation on this topic.

Big Blue Book of Bicycle Repair C. Calvin Jones, Bill Gibson, Joel King on Amazon.com.FREE. shipping on qualifying offers. Big Blue Book of Bicycle Repair; 3rd edition addresses the most advanced materials and technologies used in today's bicycles. I never dreamed the champion by provide the use of this wheel hub bearing sandals or open shoes which big blue book of bicycle repair pdf free download hubs spokes and pedaling cannot. The majority of suspension is also paying for the. Adrenaline rush and exhilarating. The Big Blue Book of Bicycle Repair is a comprehensive manual of over 130 bicycle repairs and maintenance procedures. It is written by Calvin Jones, one of the top bicycle mechanics in the country, and published by Park Tool, the world's leading manufacturer of bicycle tools. Become an authority on bicycle maintenance with the BBB-3 Big Blue Book of Bicycle Repair. Big blue book of bicycle repair pdf. Item # BBB-3 (discontinued) / Park Tool Gear / Big Blue Book Big Blue Book of Bicycle Repair — 3rd Edition. Updated with new information, techniques, photos, procedures, and components, the BBB-3 3rd Edition is a complete repair manual created to provide both the novice and veteran mechanic the information needed to perform nearly any repair from trailside repairs to complete overhauls.

Shivamarc_smarc_s

The 'ALTER DATABASE (your database) MODIFY FILE' command will only rename the logical names. This post shows how to use xp_cmdshell to also rename the physical files: http://www.mssqltips.com/sqlservertip/1891/best-practice-for-renaming-a-sql-server-database/

Access Database Files

Please note the following:
1. xp_cmdshell will be executed under the user which the SQL Server process runs as, and might not have the file system permissions required to rename the database files
2. For security reasons, remember to disable xp_xmdshell

The following is an example of how the renaming can be done based on the mentioned blog post. It will replace the database MyDB with the database NewMyDB. The original MyDB (renamed to MyDB_OLD) will be left detached.

The simplest way to rename SQL server physical database files is:

1. Open and connect to the SQL server where the database you wanted to rename is located.
2. Execute the following script in the query window in order to change the physical and logical names. Remember to replace all the 'OldDatabaseName' with the new name of the database ('NewDatabaseName') you want to change its name to. Replace all NewDatabaseName with the new name you want to set for your database

use OldDatabaseName

3. And then Right click on the OldDatabaseName, select Tasks and then choose Take Offline

4. Go to the location (C:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLDATA..) where the physical files are located and rename them to the NewDatabaseName you specified in number 2. Remember to check the absolute path of these files to be used on your computer.
5. Go back to Microsoft SQL Server Management Studio. Right click on the OldDatabaseName, select Tasks and then choose Bring Online.
6. Finally, go ahead and rename your OldDatabaseName to the NewDatabaseName. You are done :-)

Desta Haileselassie HagosDesta Haileselassie Hagos

1. Backup the original database
2. Drop the original database
3. Restore the original database from the backup, but with different name; the files of the restored database will be also automatically named taking into account new database name.

SevenateSevenate

Not the answer you're looking for? Browse other questions tagged sql-servertsqlmdfldf or ask your own question.