Viewing 15 posts - 376 through 390 (of 476 total)
elmnas (9/16/2015)
I wonder is it hard to copy an existing SQL db to a new virtual machine if I install SQL server
For me, I would restore a recent Full Backups...
September 16, 2015 at 6:13 am
GilaMonster (9/16/2015)
You'll have to change the name of Marketing before you can rename Marketing1. Even offline, it's still a database on the instance and database names have to be unique.
🙂
In...
September 16, 2015 at 3:32 am
Perhaps change the logical names of, what was, the Marketing1 database too (after the rename)
Personally I'd just use the
ALTER DATABASE [Marketing] SET OFFLINE WITH ROLLBACK IMMEDIATE
rather than first setting it...
September 16, 2015 at 2:39 am
Dunno if this might work?
SELECTa.attendingmdkey,e.[provider id],e.[first name],e.[last name],e.title,
e.specialty,l.locationname,
[Count]
FROM(
SELECTa.attendingmdkey, a.locationid, COUNT(a.accountid) AS [Count],
Row_Number() Over(
Partition by a.attendingmdkey
order by COUNT(a.accountid) desc) AS RowNum
FROMaccounts AS a
where a.dischargedate>='2014-12-01'
and a.dischargedate<'2015-01-01'
and a.divisioncode in ('1','2','$')
GROUP...
September 16, 2015 at 2:32 am
Ed Wagner (9/15/2015)
The encouraging news is that in order to copy the files, SQL Server has to release the lock on them.
Good point, thanks. My knowledge of tape backup...
September 16, 2015 at 2:19 am
Sean Lange (9/15/2015)
I absolutely can't stand it when column names change across tables. It isn't a cli_Name it is a ClientName and it is always a ClientName.
Sorry, just in case...
September 16, 2015 at 12:49 am
Lynn Pettis (9/15/2015)
Kristen-173977 (9/15/2015)
ramana3327 (9/15/2015)
Step: Moving the production server latest backup from its local drive to Test server local drive
Pedantic point but I expect that needs to be COPYING rather...
September 16, 2015 at 12:44 am
ScottPletcher (9/15/2015)
September 15, 2015 at 6:30 pm
ScottPletcher (9/15/2015)
September 15, 2015 at 5:58 pm
neil.michael (9/15/2015)
Is this normal ?
Yup. Dunno if it is a good analogy, but consider that you have a floating point number column with values 1.0, 1.1, 1.2 ... and you...
September 15, 2015 at 5:55 pm
Lynn Pettis (9/15/2015)
I would also recommend this even in single table queries as you never know when you may add table joins to a query.
Just putting a different point-of-view (its...
September 15, 2015 at 5:37 pm
Dunno if it might help get your form A to B, but would reporting off a day-old copy be possible / acceptable?
I'm thinking an overnight copy/restore to A.N.Other server, which...
September 15, 2015 at 5:26 pm
robinwilson (9/15/2015)
I have never known SQL Server to behave so badly and unpredictably and it tends to just work.
Because all your, previous, databases were written using Brest Practices perhaps?
September 15, 2015 at 5:21 pm
mike 57299 (9/15/2015)
The field is currently in use many places and changing all the references from the table to a view is a large time investment.
Would it be an...
September 15, 2015 at 5:17 pm
chrisph (9/15/2015)
the only backups are of the mdf and ldf files
I hope they were "transactionally consistent" (if that is the right word?!) when they were backed up.
Suggest running DBCC CHECKDB...
September 15, 2015 at 5:11 pm
Viewing 15 posts - 376 through 390 (of 476 total)