Viewing 14 posts - 1 through 14 (of 14 total)
how to use BCP out? i never do this b4. can u show the related articles? tq 4 info...
August 2, 2012 at 2:13 am
yes, i know that the system tables was damaged especially sysindexes & sysindexkeys. the important thing is a data from the main table. what Redgate's SQLDataCompare can do for this?...
July 31, 2012 at 9:25 am
oh, i'm so sorry...forgot to ans it. i have old backup before hard disk failure. i just get mdf & ldf file only after retrieving. i try to set emergency...
July 30, 2012 at 7:34 pm
that is for the demo version only, it just for viewing & cannot take the data unless pay more for it 🙂
July 30, 2012 at 10:45 am
if i restore the last full backup, how about the data since then lost?
July 29, 2012 at 4:14 am
when i run this...
backup log PMSdb
to disk='D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\PMSdb_Log.trn'
with NO_TRUNCATE
Server: Msg 3033, Level 16, State 1, Line 1
BACKUP DATABASE cannot be used on a database opened in emergency mode.
Server:...
July 27, 2012 at 7:55 pm
backup log PMSdb
to disk='D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\PMSdb_Log.bak'
with NO_TRUNCATE,NORECOVERY
Msg 3031, Level 16, State 1, Line 1
Option 'no_truncate' conflicts with option(s) 'norecovery'. Remove the conflicting option and reissue the statement.
backup log PMSdb
to...
July 27, 2012 at 10:29 am
backup log PMSdb
to disk='D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\PMSdb_Log.bak'
WITH NO_RECOVERY
Msg 155, Level 15, State 1, Line 3
'NO_RECOVERY' is not a recognized BACKUP option.
July 27, 2012 at 9:48 am
No truncate...
backup log PMSdb
to disk='D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\PMSdb_Log.bak'
with NO_TRUNCATE
Server: Msg 3033, Level 16, State 1, Line 1
BACKUP DATABASE cannot be used on a database opened in emergency mode.
Server: Msg 3013,...
July 27, 2012 at 9:29 am
Back up the tail of your transaction log...
is it this one?
BACKUP DATABASE [PMSdb]
TO DISK = N'D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\PMSdb.bak'
WITH NOFORMAT, NOINIT, NAME = N'PMSdb-Full Database Backup',...
July 27, 2012 at 8:26 am
Is it something error about reserved keyword?
December 3, 2011 at 6:18 pm
here is the sample data from 2 tables;
Payphone
---------
PhoneNo MF6_TelMn ...
December 3, 2011 at 7:21 am
thanks for reply my topic Lynn Pettis...
the problem is, it sometimes get error when i use keyword 'LEFT' in SQL server 2000. can i know the related topic here?
November 30, 2011 at 6:08 pm
Viewing 14 posts - 1 through 14 (of 14 total)