Rename database data file in SQL Server 2005

Posted by Jason on Stack Overflow See other posts from Stack Overflow or by Jason
Published on 2010-02-03T16:39:49Z Indexed on 2010/03/19 22:41 UTC
Read the original article Hit count: 416

Filed under:

sql-server-2005

|

sql-server-management-stu

|

SSMS

|

ssms-2005

I need to rename a databases data file. Is this possible through SQL Server Management Studio?

FYI, I do not have permissions to the underlying box.

Edit: I also need to change the location of the file.

Related posts about sql-server-management-stu

Why is SQL Server Compact Edition missing from the list of server types in SQL Server Management Stu

as seen on Stack Overflow - Search for 'Stack Overflow'
I have both 'SQL Server Compact 3.5 Service Pack 1' and 'SQL Server Management Studio 2008' (SSMS) installed on my PC. In the past, I was able to select 'SQL Server Compact Edition' from the list of 'Server Types' in the 'Connect to Server' dialog within SSMS. This entry is now missing and I have… >>> More
SQL SERVER – Generate Report for Index Physical Statistics – SSMS

as seen on SQL Authority - Search for 'SQL Authority'
Few days ago, I wrote about SQL SERVER – Out of the Box – Activity and Performance Reports from SSSMS (Link). A user asked me a question regarding if we can use similar reports to get the detail about Indexes. Yes, it is possible to do the same. There are similar type of reports are available at Database… >>> More
SQL SERVER – Out of the Box – Activty and Performance Reports from SSSMS

as seen on SQL Authority - Search for 'SQL Authority'
SQL Server management Studio 2008 is wonderful tool and has many different features. Many times, an average user does not use them as they are not aware about these features. Today, we will learn one such feature. SSMS comes with many inbuilt performance and activity reports, but we do not use it… >>> More
SQL SERVER – Concat Strings in SQL Server using T-SQL – SQL in Sixty Seconds #035 – Video

as seen on SQL Authority - Search for 'SQL Authority'
Concatenating string is one of the most common tasks in SQL Server and every developer has to come across it. We have to concat the string when we have to see the display full name of the person by first name and last name. In this video we will see various methods to concatenate the strings. SQL… >>> More
SQL SERVER – Standard Reports from SQL Server Management Studio – SQL in Sixty Seconds #016 – Video

as seen on SQL Authority - Search for 'SQL Authority'
SQL Server management Studio 2012 is wonderful tool and has many different features. Many times, an average user does not use them as they are not aware about these features. Today, we will learn one such feature. SSMS comes with many inbuilt performance and activity reports, but we do not use it… >>> More

Developer IT

Rename database data file in SQL Server 2005 - Developer IT

Rename database data file in SQL Server 2005

sql-server-2005

sql-server-management-stu

SSMS

ssms-2005

Related posts about sql-server-2005

[MAJ] SQL Server 2005 Express Edition - La version gratuite de SQL Server 2005

SQLAuthority News – Feature Pack for Microsoft SQL Server 2005 SP4

SQL Server 2005 - Syncing development/production databases

Displaying the Row Number in a SELECT Query with SQL Server 2005

Displaying the Row Number in a SELECT Query with SQL Server 2005

Related posts about sql-server-management-stu

Why is SQL Server Compact Edition missing from the list of server types in SQL Server Management Stu

SQL SERVER – Generate Report for Index Physical Statistics – SSMS

SQL SERVER – Out of the Box – Activty and Performance Reports from SSSMS

SQL SERVER – Concat Strings in SQL Server using T-SQL – SQL in Sixty Seconds #035 – Video

SQL SERVER – Standard Reports from SQL Server Management Studio – SQL in Sixty Seconds #016 – Video

Categories cloud