Solution : https://service.sap.com/sap/support/notes/363018 (SAP Service marketplace login required)
Summary :
This SAP Note provides guidelines for managing database files in SQL Server environments, applicable for version 7.0 and higher. It covers scenarios such as moving user databases and the tempdb, as well as adding and removing database files, using SQL Server Management Studio or Query Analyzers. Key commands include sp_detach_db, sp_attach_db for detaching and attaching databases, and ALTER DATABASE for modifying file storage configurations. The note advises stopping the R/3 system before moving databases and emphasizes regular backups post-modifications to ensure data integrity. Instructions also include handling tempdb which cannot be moved using sp_detach_db due to its constant usage by SQL Server.
Key words :
declare @maxint intselect @maxint=max, alter database prd add log file, alter database prd remove file prd_data4, alter database add log file command, alter database prd add file, alter database prd modify file, 'alter database modify file' command, alter database tempdb modify file, microsoft knowledgebase article q254253, /support/kb/articles/q254/2/53
Related Notes :
| 1455399 | Performance issues with DSO activation |
| 534036 | SAP LT: System settings for conversions |
| 421644 | SQL error 9002: The transaction log is full |
| 151603 | Copying an SQL Server database |