It has been a while since I worked with 6.5, but I believe that once you get
into the server, from a query window in master, issue
DUMP TRANSACTION MyDB WITH NO_LOG
This _should_ always work since it throws the log away without even
checkpointing the database. So, if this works for you immediately after you
should do a DUMP DATABASE.
You mentioned that the database was inaccessible, but not that it was marked
SUSPECT, so go ahead and try this.
In SQL server 6.5, I've got the message (the application log file is full)
after restarting the server and before login. this makes the working
database
useless and marked inaccessible. Please I need and advice how can I solve
the
problem.
Re: Connecting to a remote sbs from a website? ... Your solution only works if your web app doesn't need to write data to the database....SQL server has always supported SQL authentication which does NOT require an SBS username/password. ... And if you aren't, somebody will find a way to break you, regardless of how well you think you've secured your master database.... (microsoft.public.windows.server.sbs)
Create SharePoint Portal failed. ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ... (microsoft.public.sharepoint.portalserver)
Re: fc3 & mysql clustering ... > fault tolerance/redundancy is not just an issue of multiple mysql databases.... > machine is the slave being tied to the master,... The real trick is redundant database servers.... > server goes down the other server takes over it. ... (Fedora)
Re: ADO Connection Timeout ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ... (microsoft.public.data.ado)
Web Developers - Happy Hearts And HDTV! - Lockergnome ... Certificate on your MSIIS Web server.... getting data from a database is only half the problem. ... Zend recently started a series about building rock solid code in PHP.... which provides bulk database conversion.... (freebsd-questions)
