Re: Missing log file...

From: Radek (radek_at_obecniezwarszawy.pl)
Date: 08/18/04 

Date: Wed, 18 Aug 2004 14:01:07 +0200

> 1. Try to attach the database using
>
> EXEC sp_attach_single_file_db @dbname = 'pubs', @physname =
> 'D:\MSSQL\data\dbname.mdf'
>

It works :)
I was sure that something like this command should exist
... but I couldn't find it in manuals.
Thank You
Radek

Relevant Pages

  • WSS 2.0 to 3.0 upgrade
    ... I ran this command to attach my 2.0 contentDB to WSS 3.0: ... MYDATABASESERVER -databasename MYDATABASENAME ... Databases I am not seeing my database attached. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: create db
    ... To create a database you can make use of t-sql command "create database". ... If you want to attach a database with the existing data and log files. ...
    (microsoft.public.sqlserver.mseq)
  • RE: MOSS and move SQL database
    ... Backup the web application and check the database ... \par 1.2 Click "Perform a Backup" under Backup and Restore. ... At the command prompt, type the following command to attach the content database, and then press ENTER: ...
    (microsoft.public.sharepoint.portalserver)
  • Re: How to find the database version
    ... You can get the database version by running the below command from Query ... While you attach the database in Query analyzer you can see messages ...
    (microsoft.public.sqlserver.server)
  • RE: Event ID 447
    ... Please made a backup for Exchange database first. ... Please run the eseutil /mh command to see if the mailbox store is clean ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
Loading