do we need to take a full backup on a full recovery model database after we perform a dbcc shrink(logfile) on it?
will dbcc shrinkfile on logfiles upset the log sequence to restore the logbackups frmo the last full backup?
how about when I do truncate on logfiles, do I need to take a full backup after that?
thanks in advance.
If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):
. Check for publisher's certificate revocation
. Check for server ce…
I am showing a way to read/import the excel data in table using SQL server 2005...
Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name".
Now to import this Excel data into the table, we will use…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?