Welcome to Sign in | Help

Re: Cum sa atasez o baza de date fara fisierul de log

  •  01-16-2007, 10:52 AM

    Re: Cum sa atasez o baza de date fara fisierul de log

    Puteti folosi procedura stocata sp_attach_single_file_db ca in exemplul preluat din Books Online: 

    USE master;
    GO
    EXEC sp_detach_db @dbname = 'AdventureWorks';
    EXEC sp_attach_single_file_db @dbname = 'AdventureWorks',
        @physname = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks_Data.mdf';


    Cristian Andrei Lefter, SQL Server MVP
    MCT, MCSA, MCDBA, MCAD, MCSD .NET,
    MCTS, MCITP - Database Administrator SQL Server 2005
    http://sqlserver.ro
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems