SAP Note 363018 - File management for SQL Server

Component : Microsoft SQL Server -

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 :

1455399Performance issues with DSO activation
534036SAP LT: System settings for conversions
421644SQL error 9002: The transaction log is full
151603Copying an SQL Server database