Viewing 15 posts - 61 through 75 (of 148 total)
First ,thanks for the nice question ,I always used to thought it takes alter table command at the back end .
I have attached my results with client statistics .
Waiting for...
November 21, 2012 at 10:41 pm
Really Stupid I am ...
Thats Really Worth reading blog by Gail .
If your lucky,you will get your databases back...But anyone can realize the importance of backups from this...
November 21, 2012 at 12:21 am
did you try
EXEC sp_attach_single_file_db @dbname = 'MEDICALSTORE',
@physname =
N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\MEDICALSTORE_Data.mdf';
November 20, 2012 at 11:31 pm
November 20, 2012 at 10:58 pm
anthony.green (11/20/2012)
First off, why no backups? System database are just as important to backup as your user backups. Please tell me you backup your Master database at least?
+10000000
November 20, 2012 at 6:11 am
nitin.doshi (11/20/2012)
November 20, 2012 at 3:56 am
alex_zilberman (11/19/2012)
also
I write the statement something like this:
Backup Database [db name]
to disk = N'Path to file'
with init, Name=N'full database backup', skip, stats=10;
Is this will not truncate...
November 19, 2012 at 12:59 am
Tanaji Chougale (11/19/2012)
all things are properthis application run properly on other normal PC
what you mean by all ?
what is
1)Physical memory
2)sql/winodows server configuration
3)which query getting performance issue
4)what is the...
November 19, 2012 at 12:53 am
Also I'm so much excited for the concert by Guns N Roses in dec 2012 (First time in INDIA) 😀 .
I know without slash ,it will not be...
November 17, 2012 at 1:27 am
I play Acoustic guitar from last few years .. not dedicated as so far. Just few days back bought new Yamaha F310, my second guitar and I love it .
I...
November 17, 2012 at 1:21 am
As long as its running successfully,it should not give wrong output.
Just curious,did you used NOLOCK hint anywhere inside SP ?
November 16, 2012 at 11:33 pm
bugg (11/16/2012)
Cheers I Have used the with restore, and changed fromSET SINGLE_USER WITH
ROLLBACK IMMEDIATE
TO
ALTER DATABASE Test_DB SET OFFLINE WITH ROLLBACK IMMEDIATE
Do you think this will suffice?
No ,database will not go...
November 16, 2012 at 11:20 pm
venkat.2829 (11/16/2012)
i have give as below
SQLCMD -S servername...
November 16, 2012 at 5:45 am
bugg (11/16/2012)
sanket kokane (11/16/2012)
--Drop previous reporting database
----------------------------------------------------------
PRINT 'Check if DB exists if so drop'
GO
IF EXISTS(SELECT * FROM SYS.DATABASES WHERE NAME='ReportDB')
BEGIN
--Remove any connections
ALTER DATABASE ReportDB
SET SINGLE_USER WITH
ROLLBACK IMMEDIATE
--Drop DB
DROP DATABASE ReportDB
END
GO
setting...
November 16, 2012 at 5:40 am
Viewing 15 posts - 61 through 75 (of 148 total)